stevenh77 · April 8, 2016 15:09
diff --git a/sql-pivot.sql b/sql-pivot.sql
 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
	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