sql行转列动态与静态

if object_id('tbl_0','u') is not null drop table tbl_0
go 

create  table tbl_0
(
   color nvarchar(12),
   nsize nchar(1),
   store int
)
insert into tbl_0
select 'red',    'S',    '10' union all 
select  'red',    'M',    '80'  union all
select 'white',    'L',    '50'  union all
select  'white',    'S',    '1'  union all
select  'white',    'S',    '60'


select * from tbl_0
declare @sql varchar(4000)
declare @h varchar(2)
--注意stuff(@sql,len(@sql)-len(@h)-len(@h),1,'')
---------------------------------------------------
--动态
set @h='
'--注意stuff(@sql,len(@sql)-len(@h)-len(@h),1,'')
set @sql = 'select color,'+ @h
select @sql= @sql+'max(
case nsize 
when '''+nsize+''' 
then isnull(store,0)