Proceduce e.g.2

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[Proc_I_TB_EXHRTHIST]  
(
@CcyCde varchar(20),
@ExhRtHistDT datetime,
@ExhRtHistAmt decimal(18, 8),
@ExhRtHistCreateDT datetime,
@ExhRtHistCreateUsr varchar(20),
@ExhRtHistUpdateDT datetime,
@ExhRtHistUpdateUsr varchar(20)
)
AS
BEGIN TRANSACTION T1

    DECLARE @CCYCODE VARCHAR(20)
    DECLARE @EXHRTDT DATETIME

    SET @CCYCODE = NULL
    SET @EXHRTDT = NULL


      INSERT TB_ExhRtHist (  CcyCde,ExhRtHistDT,ExhRtHistAmt,ExhRtHistCreateDT,ExhRtHistCreateUsr,ExhRtHistUpdateDT,ExhRtHistUpdateUsr) 
       VALUES (@CcyCde,@ExhRtHistDT,@ExhRtHistAmt,@ExhRtHistCreateDT,@ExhRtHistCreateUsr,@ExhRtHistUpdateDT,@ExhRtHistUpdateUsr)
    

    SELECT @CCYCODE = CcyCde,@EXHRTDT = ExhRtDT FROM DBO.TB_EXHRT WHERE CcyCde = @CcyCde

    IF @CCYCODE IS NOT NULL
        BEGIN
            IF @ExhRtHistDT >= @EXHRTDT
                BEGIN
                    UPDATE TB_EXHRT SET
                    ExhRtDT=@ExhRtHistDT,
                    ExhRtAmt=@ExhRtHistAmt,
                    ExhRtUpdateDT=@ExhRtHistUpdateDT,
                    ExhRtUpdateUsr=@ExhRtHistUpdateUsr    
                    WHERE CcyCde = @CCYCODE
                END
        END
    ELSE
        BEGIN 
            INSERT INTO TB_EXHRT(CcyCde, ExhRtDT, ExhRtAmt, ExhRtCreateDT, ExhRtCreateUsr, ExhRtUpdateDT, ExhRtUpdateUsr)
            VALUES(@CcyCde, @ExhRtHistDT, @ExhRtHistAmt, @ExhRtHistCreateDT, @ExhRtHistCreateUsr, @ExhRtHistUpdateDT, @ExhRtHistUpdateUsr)
        END

COMMIT TRAN T1