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 |
|
Fatalsniper
Starting Member
45 Posts |
 Posted - 2005-12-06 : 17:40:26
|
| Hey guys!,I have this tableDate.........................SUM...name --------------------------- ----- -----------2005-11-10 00:00:00.000-----4------John2005-11-03 00:00:00.000-----16-----user12005-11-04 00:00:00.000-----12-----user2..2005-11-09 00:00:00.000-----15-----userNand I want to TRANSFORM it to this...Date........................John....User1..Total_Amount--------------------------- ------- ---- ----------- 2005-11-03 00:00:00.000....16......0......162005-11-04 00:00:00.000....12......0......122005-11-08 00:00:00.000....7.......4......11And get all users as columns instead rows...dynamicly if possibleAny suggestions???Thanks in advance... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-06 : 19:44:04
|
| see here[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6216[/url]-----------------[KH] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Complex Query