DECLARE @CARDCODE AS NVARCHAR
DECLARE OCRD1 CURSOR 
FOR
SELECT * from z_dtw_queue
OPEN OCRD1
FETCH OCRD1 INTO @CARDCODE
WHILE @@FETCH_STATUS=0
BEGIN
UPDATE OCRD
SET U_STOXOS=@CARDCODE
FETCH OCRD1 into @CARDCODE
END
CLOSE OCRD1