cursor2

DECLARE @CARDCODE AS NVARCHARDECLARE OCRD1 CURSOR FORSELECT * from z_dtw_queueOPEN OCRD1FETCH OCRD1 INTO @CARDCODEWHILE @@FETCH_STATUS=0BEGINselect cardname from ocrd where cardcode=@cardcodeUPDATE OCRDSET U_STOXOS=@CARDCODEFETCH OCRD1 into @CARDCODEENDCLOSE OCRD1