PIVOT in SQL SERVER

Question

I have two columns Name and Values. I need a query to PIVOT the values from column to row. Please do help me out on this. I just want to learn how PIVOT works Thanks in Advance

Nitin Sontakke · Answer

Why not just google and try it yourself? Isn't it better to follow the link where it is explained in detail than we put together information which is already available elsewhere. Generally dedicated articles / blogs explain things a lot more detail than we possibly could. In addition it will be clearer to you only when you do it yourself in SSMS.

Antony Clinton · Answer

It would be helpful if i get a query example to the scenario i mentioned. So that i can learn from that

Ramesh Palanivel · Answer

Hi Antony Try this link http://data.stackexchange.com/stackoverflow/query/580181 You can learn pivot table in sql server...