Hi,
I want to show vertical rows data in horizotal.
For EG:
ID Name
1 Pravin
1 VJ
2 Akash
3 Dhan
Result Should be:
ID Name
1 Pravin,VJ
2 Akash
3 Dhan
Is it possible.
Plz help
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
MuthuMari MPosted Apr 4, 2012, 6:46 AM
I think u may use pivot.
pls refer this i think, u will get some ideas.
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/
Thanks!