Create Table Test (Name Char (10), KM Char (10), CJ Int) GoInsert Test Values ('Zhang San', 'Language', 80) Insert Test Values ('Zhang San', 'Mathematics ", 86) Insert Test Values ('Zhang San', 'English', 75) INSERT TEST VALUES ('Li Si', 'Language', 78) Insert Test Values ('Li Si', 'Mathematics ", 85) Insert Test Values (' Li Four ',' English ', 78) / * want to become
Name Language Mathematics English Zhang San 80 86 75 Li Si 78 85 78 * /
Declare @sql varchar (8000) set @SQL = 'select name'SELECT @SQL = @SQL ', SUM (Case Km When '' ' Km ' '' Ten CJ End) [' KM '] 'from SELECT DISTINCT KM from test) as aselect @SQL = @ SQL 'from test group by name'exec (@SQL)
Drop Table Test
