Something

DECLARE @CARDCODE AS NVARCHARDECLARE OCRD1 CURSOR FORSELECT * from z_dtw_queueOPEN OCRD1FETCH OCRD1 INTO @CARDCODEWHILE @@FETCH_STATUS=0BEGINUPDATE OCRDSET U_STOXOS=@CARDCODEwhere cardcode=@CARDCODEFETCH OCRD1 into @CARDCODEENDCLOSE OCRD1