apriori.sql

sql server 2000 行列转置

declare @sql varchar(8000)

set @sql = 'select CusCode,'
select @sql = @sql + 'sum(case itemname when '''+itemname+''' 
then 1 else 0 end) as '''+itemname+''','
from (select distinct itemname from Saletable) as a 
select @sql = left(@sql,len(@sql)-1) + ' from Saletable group by CusCode'
exec(@sql)