USP_CONDITIONSETTING_SETCONDITION

CREATE procedure dbo.USP_CONDITIONSETTING_SETCONDITION
(
    @NAME nvarchar(100),
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTDATE datetime = null
)
as 
    set nocount on;

    if not exists
    (
        select
            1
        from
            dbo.CONDITIONSETTING
        where
            CONDITIONSETTING.NAME = @NAME
    )
        begin
            if @CURRENTDATE is null
                set @CURRENTDATE = getdate();

            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            insert into dbo.CONDITIONSETTING (NAME, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values (@NAME, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
        end

    return 0;