Blog Post

Understanding the PIVOT function

,

The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron Talmage and their study guide Exam 70-461: Querying Microsoft SQL Server 2012 for the brilliant explanation. Here’s their example replicated here. Remember there are 3 columns used in PIVOT. The Grouping column is what you […]

Read 2,902 times
(15 in last 30 days)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating