SQL 2000动态交叉表

declare @sqlText nvarchar(4000)

select @sqlText='select supplier,'
 
select @sqlText=@sqltext+'(CASE customer WHEN '''+customer+''' THEN quantity ELSE 0 END) AS ''' +customer+
    ''',' from (select distinct customer from vw_samplelist) as a

select @sqlText=left(@sqlText,Len(@sqlText)-1)+' from vw_samplelist'
print @sqltext
exec(@sqlText)
go