SQL行转列.docVIP

SQL行转列 ip: 113.28.86.162,41433 用戶名和密码: chimei01 exec UP_DayMaterial_Proc1 @startTime = 10 1 2012 12:00:00:000AM, @endTime = 10 1 2012 11:59:59:000PM, @ModeTag = 1, @Language = 0, @ProductLine = --------------------------------- select CustomerName,SiteCode,SiteName,Cgrade,Project,Sum(Volume) as Volume,Sum(DocketVolume) as DocketVolume,Count(*) as Ttruckcount into #A from ProdMasterData where Product_Tag=0 and ModeTag=1 and Pdate=10 1 2012 12:00:00:000AM and Pdate= 10 1 2012 11:59:59:000PM and ProductLine like %++% Group by CustomerName,SiteCode,SiteName,Project,Cgrade -------------------- select * into #temp from (select 0 as sort,CustomerName as 客户名称,SiteCode as 工地代码,SiteName as 工地名称,Project as 工程部位,Cgrade as 强度等级, (select Volume from #A where #A.CustomerName = ProdMasterData.CustomerName and #A.SiteCode = ProdMasterData.SiteCode and #A.SiteName = ProdMasterData.SiteName and #A.Project = ProdMasterData.Project and #A.Cgrade = ProdMasterData.Cgrade) as 生产方量, (select DocketVolume from #A where #A.CustomerName = ProdMasterData.CustomerName and #A.SiteCode = ProdMasterData.SiteCode and #A.SiteName = ProdMasterData.SiteName and #A.Project = ProdMasterData.Project and #A.Cgrade = ProdMasterData.Cgrade) as 票据方量, (select Ttruckcount from #A where #A.CustomerName = ProdMasterData.CustomerName and #A.SiteCode = ProdMasterData.SiteCode and #A.SiteName = ProdMasterData.SiteName and #A.Project = ProdMasterData.Project and #A.Cgrade = ProdMasterData.Cgrade) as 车次,sum(case when ConsumpMaterial.MaterialName = 粉煤灰1 then ConsumpMaterial.MAct else 0 end) as 粉煤灰1,sum(case when ConsumpMaterial.MaterialName = 粉煤灰2 then ConsumpMaterial.MAct else 0 end) as 粉煤灰2,sum(case when ConsumpMaterial.MaterialName = 附加料1 then ConsumpMaterial.MAct else 0 end) as 附加料1,sum(case when ConsumpMaterial.MaterialName = 附加料2 then ConsumpMaterial.MAct else 0 end) as 附加料2,sum(case when ConsumpMaterial.MaterialName = 矿粉1 then ConsumpMaterial.MAct else 0 end) as 矿粉1,su