declare @tab varchar(20) set @tab='表名' print('select sum(case when col1=''a01'' then col3 else 0 end)a01, sum(case when col1=''a01'' then col3 else 0 end)b01, sum(case when col1=''a01'' then col3 else 0 end)c01, sum(case when col1=''a01'' then col3 else 0 end)d01 from '+@tab+' group by col1')
select (select Sum(数量) from a)a Cross join (select Sum(数量) from b)b Cross join (select Sum(数量) from c)c Cross join (select Sum(数量) from d)d
select (select Sum(数量) as a01 from a01)a Cross join (select Sum(数量) as b01 from b01)b Cross join (select Sum(数量) as c01 from c01)c Cross join (select Sum(数量) as d01 from d01)d
select * from (select Sum(数量) as a01 from a01)a Cross join (select Sum(数量) as b01 from b01)b Cross join (select Sum(数量) as c01 from c01)c Cross join (select Sum(数量) as d01 from d01)d 这样对了,谢谢各位,马上给分
set @tab='表名'
print('select sum(case when col1=''a01'' then col3 else 0 end)a01,
sum(case when col1=''a01'' then col3 else 0 end)b01,
sum(case when col1=''a01'' then col3 else 0 end)c01,
sum(case when col1=''a01'' then col3 else 0 end)d01
from '+@tab+' group by col1')
varchar(20) --改大一点varchar(100),刚才就因为这一分没拿到
select
(select Sum(数量) from a)a
Cross join
(select Sum(数量) from b)b
Cross join
(select Sum(数量) from c)c
Cross join
(select Sum(数量) from d)d
(select Sum(数量) as a01 from a01)a
Cross join
(select Sum(数量) as b01 from b01)b
Cross join
(select Sum(数量) as c01 from c01)c
Cross join
(select Sum(数量) as d01 from d01)d
在关键字 'Cross' 附近有语法错误。怎么回事?
(select Sum(数量) as a01 from a01)a
Cross join
(select Sum(数量) as b01 from b01)b
Cross join
(select Sum(数量) as c01 from c01)c
Cross join
(select Sum(数量) as d01 from d01)d
这样对了,谢谢各位,马上给分