Table row-to-Column

This article references a web hero and the specific address cannot be found.
Create Table T (ID int identity, name varchar (10), Code INT)

Insert T values ('Population', 20)

Insert T values ('Economic', 12)

Insert T values ('Culture', 15)

Insert T values ('Land', 45)

Insert T values ('Land', 545)

 

Declare @ SQL varchar (1000)

Set @ SQL =''

Select @ SQL = @ SQL + name + '= sum (case when name = ''' + name + ''' then code else 0 end), 'From T group by name

Print @ SQL

Set @ SQL = left (@ SQL, Len (@ SQL)-1)

Set @ SQL = 'select' + @ SQL + 'from t'

Exec (@ SQL)

Drop table t