MERGE INTO MWIPEXTRES AUT USING (SELECT 'X' AS DUAL) DUAL ON ( AUT.RES_NO = @IN_RES_NO ) WHEN MATCHED THEN UPDATE SET UPTUSER = @IN_UPD_ID ,UPTDATE = GETDATE() WHEN NOT MATCHED THEN INSERT ( RES_NO ,KIT_LOT_NO ,SEQ ) VALUES ( @IN_RES_NO ,@IN_KIT_LOT_N