Skip to content

Instantly share code, notes, and snippets.

@stevenh77

stevenh77/sql-pivot.sql

Created April 8, 2016 15:10
Show Gist options
  • Save stevenh77/07fbca8403329f6f2cca7508b397e092 to your computer and use it in GitHub Desktop.
Save stevenh77/07fbca8403329f6f2cca7508b397e092 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql-pivot.sql
select * from Source_Table;
select * from
( select
person,
country,
'country' + cast(rank()
over (partition by person order by id)
as varchar(10))
as countryrank
from dbo.Source_Table) as rankedSource
pivot
( max (country) for countryrank in (country1, country2)) as pivottable;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment