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 |
|
koffiemokje
Starting Member
1 Post |
 Posted - 2007-07-11 : 08:40:21
|
Hi all,I'm not sure if this can be done but here goes:I need this table:id type1 2371 123 5017 12097 17 128 123 As an output table like this:id type1 type2 type31 237 12 03 501 0 07 1209 1 128 123 0 0 Can anyone please help me?Thanks in advance! |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-11 : 08:44:50
|
| Read about Cross-tab reports in sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
crosstable? or something else...