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 |
|
vbandlamudi
Starting Member
1 Post |
 Posted - 2008-08-28 : 02:14:48
|
| please check this out:my data is like as folowsorder_num prdo_grp level10001 [lux][santoor] 110002 [grp][app] 220003 [htc][hutch] 3result should be like as follows[ contains only one record]order_num submission order1 order2 order310001 [lux][santoor] [grp][app] [htc][hutch] nulleverytime it should take the order number as level1 order number. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-28 : 02:17:52
|
check out PIVOT operator
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-28 : 03:57:27
|
| where does submission come from? |
|
|
|
|
|
|
Pivoting data