专门搞Ａ８数据

qazwsxedc

本人可以提供a8目前没有的功能开发，比如要查询所帐套中库存为０的所有商品名称：
DECLARE  @BB VARCHAR(100)
set @BB=''
select kid,pid,sum(qty) as 帐面数量,avg(price) as 平均价,sum(totalmoney)as 帐面金额,sum(inqty)as 采购数,sum(outqty)  into #A from　数据表名
group by kid,pid
having kid in (select _id from 数据表名　where [email=fullname=@BB]fullname=@BB[/email])
select b.fullname,c.fullname,a.帐面数量,a.平均价,a.帐面金额 from #A as a
inner join 数据表名 b on a.pid=b._id
inner join 数据表名  c on a.kid=c._id
where outqty='0.00'
order by b.fullname