I need the query which is used to convert rows into columns.
I have tried with ROW_NUMBER() OVER(PARTITION BY USERID ORDER BY USERID) R function,but it is not working.
Could you please let me know if any other alternative is there.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello Sandhya and welcome to the forums,
Please post example data of some rows in a table and the data you want for output from these rows. This does not need to be a large volume, but should be enough to show what you want to do.
When posting data, it is best to use the "Code" tag near the top of the reply panel as it makes your post much more readable. You can also "Preview" your post and see how it will appear to the forum and then click "Submit" when you are satisfied with how your post appears.