Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Troubles creating query

Author  Topic 

djorre
Yak Posting Veteran

94 Posts

Posted - 2010-01-04 : 07:34:18
Hi,

As a novice, I experience some troubles converting this query.

I need to move from this

tbl_sourcedestination
Source Destination
Dropping1 Tank4
Tank4 Tank5
Tank4 Tank6
Tank5 End1

To this

tbl_fullroutes
Route1 Route2 Route3 Route4 Route5 ...
Dropping1 Tank4 Tank5 End1 NULL
Dropping1 Tank4 Tank6 NULL NULL

Can someone please help or give a hint in how to do this in the best way?

Thanks so much!
   

- Advertisement -