use [new_wzjw] go /****** object: storedprocedure [dbo].[成绩管理_过程化成绩录入_统计最终成绩] script date: 2014/4/1 19:22:01 ******/ set ansi_nulls on go set quoted_identifier on go alter proc [dbo].[成绩管理_过程化成绩录入_统计最终成绩]
use [new_wzjw]
go
/****** object: storedprocedure [dbo].[成绩管理_过程化成绩录入_统计最终成绩] script date: 2014/4/1 19:22:01 ******/
set ansi_nulls on
go
set quoted_identifier on
go
alter proc [dbo].[成绩管理_过程化成绩录入_统计最终成绩]
@kcid jxrw_code
as begin
declare c1 cursor for
select zzcj.cj,zzcj.xh from
(select xh from web_inputcj_cjb where kcid=@kcid)xsxx
left join
(select xh,round(sum(cjbl*0.01*isnull(cj,0)),0)cj from web_inputcj_xscjb xscjb left join
(select ksid,cjbl from web_inputcj_xsksb where kcid=@kcid)ksxx
on xscjb.ksid=ksxx.ksid group by xh
)zzcj on zzcj.xh=xsxx.xh
declare @cj float
declare @xh varchar(12)
open c1
fetch c1 into @cj,@xh
while @@fetch_status = 0
begin
update web_inputcj_cjb set cj=@cj where xh=@xh and kcid=@kcid
fetch c1 into @cj,@xh end
end
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！