There is a sales record table SellTable:
Local Products Number Beijing A 10 Beijing B 12 Beijing D 123 Shanghai A 257 Shanghai C 142 Tianjin D 214 Beijing A 20 Beijing B 20 Beijing D 123 Shanghai A 76969 Shanghai C 2536 .... ..... please Write a stored procedure, turn it into the following statistics table ReportTable: Local A B C d ......... Beijing 30 32 0 246 ... Shanghai .. .. .. .. Tianjin. .. .. .. .. ....... .. .. .. .. .. ..
This column number is uncertain in the MS SQLServer, it is very good in MS SQL Server: declare @SQL VARCHAR (8000) set @SQL = 'select name,' select @SQL = @SQL 'SUM (Case Subject when' ' SUBJECT '' '' '' '' '' '' SUBJECT '', 'from (Select Distinct Subject from Test) AS ASELECT @SQL = Left (@ SQL, LEN (@SQL) -1) ' From test group by name'exec (@SQL) Go
