SQL multi-Table return Summary Results

The t-sqlcompute function is currently only used in 2008 .. Others have tried withtb (id, product, barcode, qty) as (select1, AA, 240, 3unionallselect2, BB, 245, 2unionallselect3, AA, 255, 2unionallselect4, BB, 240,1) select * fromtbcomputesum (qty), sum (bar

The t-sqlcompute function is currently only used in 2008 .. Others have tried with tb (id, product, barcode, qty) as (select 1, 'A', 3 union all select 2, 'bb ', 245, 2 union all select 3, 'A', 255, 2 union all select 4, 'bb ',) select * from tb compute sum (qty), sum (bar

T-SQL compute Function
Currently, it is only used in 2008 .. Have you tried anything else? <无>

with tb(id,product,barcode,qty) as(select 1,'AA',240,3union all select 2,'BB',245,2union all select 3,'AA',255,2union all select 4,'BB',240,1)select * from tb compute sum(qty),sum(barcode)