USP_QUERIESWITHDELETEERROR_ADD

create procedure dbo.USP_QUERIESWITHDELETEERROR_ADD(
@QUERYID uniqueidentifier = null,
@DELETEERRORMESSAGE nvarchar(250) = null,
@CHANGEAGENTID uniqueidentifier = null
)
as
        set nocount on;
        declare @CURRENTDATE datetime;
        set @CURRENTDATE = getdate();

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

         begin try
         if not exists (select 1 from QUERYWITHDELETEERROR where QUERYID = @QUERYID)
            insert into dbo.QUERYWITHDELETEERROR
                (ID,
                QUERYID,
                DELETEERRORMESSAGE,
                ADDEDBYID,
                CHANGEDBYID,
                DATEADDED,
                DATECHANGED
                )
            values
                (newid(),
                @QUERYID,
                @DELETEERRORMESSAGE,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
                )
        end try

        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch

        return 0;