|
|
Posted by Alex on 06/21/06 21:28
Hello all,
I'm at a loss on how to do this. We're using MS SQL 2000 Server and I
have a list of fields I need to find the first and last entry for.
Here's an example of the table:
Number - VarChar(10)
Jan - Int
Feb - Int
Mar - Int
Apr - Int
May - Int
June - Int
ANd it'll look something like this:
Number Jan Feb Mar Apr May Jun
1232 200 190 192 201 203 205
4432 433 322 456
5423 754 694 665
And I need to create a table with this:
Number First Last Difference
1232 200 205 5
4432 433 456 23
5423 754 665 -89
I'm not sure if this'll copy over correctly, but I have gaps in the
data so I can't just say Jun-Jan, but I need tofind the first field
with data and last field with data, then find the difference of these.
Suggestions? Is there a loop or something I can do in TSQL that'll do
this? I'd like to do this in Query Analyzer since it's just a one-time
report. Thanks --
Alex
Navigation:
[Reply to this message]
|