尺码打横 SELECTCangKuMC,BianMa,MingCheng,YanSeTM,YanSeMC,ShuLiang,ChiMaMC,LingShouJ,zhuGongYS intoxiaoshoud1 FROM[dbo].[v_QiMo_KuCunSP_XiMu]where1=1 DECLARE@sqlvarchar(4000) SET@sql='selectzhuGongYS,CangKuMC,BianMa款号,MingCheng名称,YanSeTM颜色代号,YanSeMC颜色' select@sql=@sql+',sum(caseChiMaMCwhen'''+ChiMaMC+'...