Select spbh,spmch,shpgg,shpchd,kfname,sum(sp_kfpc.shl) as shl into #temptable From sp_kfpc,huoweizl,spkfk where sp_kfpc.kfid=huoweizl.kfid and sp_kfpc.spid=spkfk.spid Group By sp_kfpc.kfid,sp_kfpc.spid,kfname,spbh,spmch,shpgg,shpchd 能够实现上面的我题目的要求, 但我是求用游标如何实现,谢谢
我现在不是考虑性能的问题,主要是学习那样使用嵌套游标的问题, 谢谢abc_sk() ( )提供的方法,但我想知道 select spid,kfid from sp_kfpc group by spid,kfid having(count(*)>1) 与Group By kfpc.kfid,sp_kfpc.spid,kfname,spbh,spmch,shpgg,shpchd的区别是什么?
From sp_kfpc,huoweizl,spkfk
where sp_kfpc.kfid=huoweizl.kfid and sp_kfpc.spid=spkfk.spid
Group By
sp_kfpc.kfid,sp_kfpc.spid,kfname,spbh,spmch,shpgg,shpchd
能够实现上面的我题目的要求,
但我是求用游标如何实现,谢谢
谢谢abc_sk() ( )提供的方法,但我想知道 select spid,kfid from sp_kfpc group by spid,kfid having(count(*)>1) 与Group By kfpc.kfid,sp_kfpc.spid,kfname,spbh,spmch,shpgg,shpchd的区别是什么?