Cyclic processing--sqlserver

Alter PROCEDURE [dbo]. [Sp_gongzi] @gongzi_yf varchar (7) AS
DECLARE @input_id varchar (20)
DECLARE @sk_sum Decimal (18, 3)
DECLARE @sk_sum_yk Decimal (18, 3)
BEGIN
DECLARE Cur_input CURSOR for
Select Docno from tc_tab1 where YF = @gongzi_yf

OPEN Cur_input

FETCH Cur_input into @input_id
While @ @FETCH_STATUS = 0
BEGIN
Set @sk_sum = 0
Set @sk_sum_yk = 0
Select @sk_sum = SUM (JE * case when (HL2 was null) then HL else HL2 end)
From Sk_dan where docno[email protected]_id;

Select @sk_sum_yk = SUM (JE * case when (HL2 was null) then HL else HL2 end)
From Sk_dan_yk where docno[email protected]_id;

Set @sk_sum = case when (@sk_sum was null) then 0 else @sk_sum end;
Set @sk_sum_yk = case when (@sk_sum_yk was null) then 0 else @sk_sum_yk end;

Update TC_TAB1 Set dke2 = @sk_sum + @sk_sum_yk
where docno = @input_id;

FETCH Cur_input into @input_id
END
CLOSE Cur_input
Deallocate cur_input
--*/
END

Cyclic processing--sqlserver