Viewing 15 posts - 721 through 735 (of 1,114 total)
Gila,
How many different codes are there?
Around 2000 codes are there.
May 7, 2008 at 9:11 am
Jeff,
Excellent Article!
It seems that you have written for me at the right time.:) Really, It is very useful for me.
Because so far i have replaced more than 5 cursors and...
May 7, 2008 at 4:01 am
Luke,
You're creating a Temp table (or adding a column to your existing, I wasn't sure which) with a number column that you were going to populate and then doing the...
May 6, 2008 at 8:40 am
No. I haven't given answer.
What i did was just suggested one way to accomplish this task.
MID Status Code Number
1 ...
May 6, 2008 at 8:38 am
I have modifed the code as below
SELECT SP,Year,Month,DATEADD(DAY,-1,DATEADD(MONTH,(N),DateStart)) AS x
FROM #A1,Tally
WHERE N-1 <= case when DATEDIFF(MONTH,DateStart,DateEnd)
It is working fine now.
May 6, 2008 at 8:16 am
After that
select MID,Status,Code
from Emp
where Number = 1
will give the first row. Am i correct ?
May 6, 2008 at 4:04 am
I do agree all of your words.
But i dont have any IDENTITY column in that table, i want to hit the table as it is 'PHYSICAL ORDER BASED SEARCH'.
If i...
May 6, 2008 at 3:56 am
Is MID an identity column? If this is not ordered by MID (within code of course) how do define what is "first"?
No.
IMHO = In my humble opinion....
May 5, 2008 at 8:04 am
Viewing 15 posts - 721 through 735 (of 1,114 total)