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 |
|
nori_venkat
Starting Member
2 Posts |
 Posted - 2009-07-04 : 00:56:41
|
| Hi,I've a requirement to display the data in rows as columnwise.Ex:Code, Doc No. Quantity date----------------------------123 000123 100 01/05/09123 000124 125 10/05/09123 000125 75 15/05/09to be displayed as 123 000123 100 01/05/09 000124 125 10/05/09 000125 75 15/05/09is it possible to display with sql queryplease helpRamana Nori |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-07-04 : 02:40:11
|
| see this linkhttp://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx |
 |
|
|
|
|
|
display data columnwise