Posted by SQLNull on 09/29/02 11:52

Hello!

I have a table that looks like this:

Col1; Col2; Col3; Col4; Col5
38; 75; 233; 916; 2770
38; 75; 233; 916; 2771
38; 75; 233; 916; 2772
38; 75; 233; 923; 2654
38; 75; 233; 923; 2655
38; 75; 245; 913; 2454
38; 75; 245; 913; 2456
....

And I need a query (not a procedure) that shows me this:
38; NULL; NULL; NULL; NULL
NULL; 75; NULL; NULL; NULL
NULL; NULL; 233; NULL; NULL
NULL; NULL; NULL; 916; NULL
NULL; NULL; NULL; NULL; 2770
NULL; NULL; NULL; NULL; 2771
NULL; NULL; NULL; NULL; 2772
NULL; NULL; NULL; 923; NULL
NULL; NULL; NULL; NULL; 2654
NULL; NULL; NULL; NULL; 2655
NULL; NULL; 245; NULL; NULL
NULL; NULL; NULL; 913; NULL
NULL; NULL; NULL; NULL; 2454
NULL; NULL; NULL; NULL; 2456
....

Does anybody know how i can get this result? How?

Help! Thank you!
SQLNull

ps: SQL-Server 2000

• Next in forum: stored procedure question
• Prev in forum: Re: Query: union on self
• Thread view: Hierarchy

[Reply to this message]