SQL Server数据库动态交叉表的参考示例: –建立测试环境set nocount oncreate table test(model varchar(20),date int ,qty int)insert into test select 本文来源gao@daima#com搞(%代@#码网‘a’,’8′,’10’insert into test select ‘a’,’10’,’50’insert into test select ‘b’,’8′,’100’insert in
SQL Server数据库动态交叉表的参考示例:
–建立测试环境set nocount oncreate table test(model varchar(20),date int ,qty int)insert into test select ‘a’,’8′,’10’insert into test select ‘a’,’10’,’50’insert into test select ‘b’,’8′,’100’insert into test select ‘b’,’9′,’200’insert into test select ‘b’,’10’,’100’insert into test select ‘c’,’10’,’200’insert into test select ‘d’,’10’,’300’insert into test select ‘e’,’11’,’250’insert into test select ‘e’,’12’,’100’insert into test select ‘f’,’12’,’150’go–测试declare @sql varchar(8000)set @sql=’select model,’select @sql=@sql+’sum(case when date=”’+cast(date as varchar(10))+”’ then qty else 0 end)[‘+cast(date as varchar(10))+’],’from (select distinct top 100 percent date from test order by date)aset @sql =left(@sql,len(@sql)-1)+’ from test group by model’exec(@sql)–删除测试环境drop table test set nocount off/**//*model 8 9 10 11 12——————– ———– ———– ———– ———– ———–a 10 0 50 0 0b 100 200 100 0 0c 0 0 200 0 0d 0 0 300 0 0e 0 0 0 250 100f 0 0 0 0 150*/ |
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：SQL Server数据库动态交叉表的参考示例
转载请注明原文链接：SQL Server数据库动态交叉表的参考示例
