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.
| Author |
Topic |
|
bjcc77
Starting Member
5 Posts |
 Posted - 2006-02-23 : 08:29:57
|
| Hi I have some a table result like this Ref Desc Date Amt2743 Deposit 12/01/06 3502743 Deposit 15/01/06 3002743 Final 17/01/06 3402744 Deposit 16/01/06 2552744 Final 18/01/06 3442745 Deposit 19/01/06 8502745 Deposit 25/01/06 4002745 Final 27/01/06 400I need the rows turned into columns to look like thisRef Desc1 Date 1 Amt1 Desc2 Date2 Amt2 Desc3 Date3 Amt32743 Deposit 12/01/06 350 Deposit 15/01/06 300 Final 17/01/06 3402744 Deposit 16/01/06 255 Final 18/01/06 344 Null null null2745 Deposit 19/01/06 850 Deposit 25/01/06 400 Final 27/01/06 400The reference number is the only common column |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Column formating