Click here to Skip to main content
14,643,202 members
Rate this:
Please Sign up or sign in to vote.
See more:
flano   PresentAmps
3   9
5   6
5   6
1   27
3   5
3   14


i want the out put like
1 3 5
27 9 6
5 6
5
14
based on the first column values i want split that values as headers fallowed by second column values as header's data.how can i get it in sql server.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Read MSDN[^] thread... Similar question is also posted over there...
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100