USE [FastMoneyPro_Remit] GO /****** Object: StoredProcedure [dbo].[ws_int_proc_responseLog] Script Date: 9/27/2019 1:30:14 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[ws_int_proc_responseLog] @flag VARCHAR(10) = NULL ,@requestId BIGINT = NULL ,@errorCode VARCHAR(10) = NULL ,@errorMsg VARCHAR(MAX) = NULL AS SET NOCOUNT ON /* s - Standard Send u - SMA USA Send o - Other Methods sp_helptext ws_int_proc_responseLog */ IF @flag = 's' BEGIN UPDATE apiRequestLog SET errorCode = @errorCode ,errorMsg = @errorMsg WHERE rowId = @requestId RETURN END IF @flag = 'u' BEGIN UPDATE apiRequestLogSMA SET errorCode = @errorCode ,errorMsg = @errorMsg WHERE rowId = @requestId RETURN END IF @flag = 'o' BEGIN UPDATE requestApiLogOther SET errorCode = @errorCode ,errorMsg = @errorMsg WHERE rowId = @requestId RETURN END GO