SQL Server data pivot (rows to columns)

SQL Server data pivot (rows to columns).sql

-- Based on this article: http://modern-sql.com/use-case/pivot

set nocount on

declare @Table table (
	TableName char(20),
	AttributeName char(20),
	AttributeValue char(20),

	-- Mandatory: Each attribute must appear precisely once for each element.
	-- Otherwise the MAX aggregate will potentially return incorrect values.
	primary key (TableName, AttributeName)
)

insert into @Table (TableName, AttributeName, AttributeValue) values
('Table1', 'Name', 'XXX'),
('Table1', 'Description', 'YYY'),
('T2', 'Name', 'hello'),
('T2', 'Description', 'desc')

select
	TableName,
	Name = max(case when AttributeName = 'Name' then AttributeValue end),
	Description = max(case when AttributeName = 'Description' then AttributeValue end)
from @Table
group by TableName