The table is as follows: a b ------------ A 10B 5A 5C 4C 8
How to use SQL statements into a b c --------- 15 5 12Declare @SQL varchar (8000) set @SQL = '' select @ SQL = @ SQL '[' RTRIM (a) '] = SUM (Case A When '' RTRIM (a) '' 'Ten B Else 0 end),' from table1 group by ASET @ SQL = Left (@ SQL, LEN (@SQL) -1) Print @sqlexec ( 'SELECT' @ SQL 'from table1') Create Table Jzlist (Child VARCHAR (10), Vaccine Varchar (10), Pre-Feed DateTime) Insert Into JzlistSelect 'Wu Shaoyang', 'Ka Medium', '2001-02-03' Union All Select 'Wu Shaoyang', 'Sugar Pills', '2001-03-25'Union All Select' Wu Shaoyang ',' Hepatitis B, '2001-04-06'Union All Select' Ningyuan ',' Ka Medium ',' 2002 -08-03'Union All Select 'Ningyuan', 'Sugar Pills', '2002-11-25'Union All Select' Ningyuan ',' Hepatitis B, '2002-12-23'Union All Select' Li Xiaoying ',' KaMoon ',' 2003-01-03'Union All Select 'Li Xiaoying', 'Sugar Pills', '2003-04-26'Union All Select' Li Xiaoying ',' Hepatitis B ',' 2003-05-01'go
- Query processing: declare @s varchar (8000) set @S = '' SELECT @ s = @ s ', [' vaccine '] = max (Case WHEN vaccine =' ' vaccine ' '' Then Convert (CHAR (10), Pre-Feed Date, 120) End 'from (Select Distinct Vaccine from Jzlist Aaexec (' SELECT Child ' @ S ' from Jzlist Group BY Children ') GO
