mwl0work的专栏

select a.tillid,num1+isnull(num2,0)   FROM  (select tillid,sum((qty + 99)/100) num1           FROM dstrans2          WHERE txdate = '2012-09-30'            AND qty > 0  group by tillid) a left jo

select tillid ,sum(num) from (select tillid,case when qty > 0 then (qty + 99)/100      when qty   end as num           FROM dstrans2          WHERE txdate = '2012-09-30') a group by tillid