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 |
|
monuindia2002
Starting Member
1 Post |
 Posted - 2006-11-17 : 20:40:43
|
| Hi I have following data in a tableColA ColB ColC ColD ColE1 NE A CM 52 NE A MU 7 3 NE A NO 9I want to write a query which returns me resultset like this ColB ColC ColD ColE ColD ColE ColD ColENE A CM 5 MU 7 NO 9can any body tell me, what will be the query for this result set.RegardsMahesh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-17 : 21:13:55
|
| Search for CROSS TAB Queries here, you will find plenty of examples.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Self Join In SqlServer