Converting columns into Rows using UnPivot in SQL Server

UnPivot is used to convert columns into rows.

We have below mentioned table who columns we want to convert into rows.


select PlayerName,Tournament,TotalScore
from TournamentScore
Tournament  in ([UTU],[Zonal])
) as UnPivotex

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: