USP_RECORDOPERATION_ADHOCQUERYBUSINESSPROCESSADD

CREATE procedure dbo.USP_RECORDOPERATION_ADHOCQUERYBUSINESSPROCESSADD
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

            if not exists (select ID from dbo.ADHOCQUERYDEPENDENCYBUSINESSPROCESS where ID = @ID) 
                insert into dbo.ADHOCQUERYDEPENDENCYBUSINESSPROCESS 
                (ID, 
                ADHOCQUERYID, -- Populating this column with the same @ID, so we actually deleting the query this table entry gets deleted (cascade)

                NAME,
                DESCRIPTION,
                ADDEDBYID,
                CHANGEDBYID)
            values
                (@ID,
                @ID,
                'Process for query with ID '+ convert(nvarchar(50), @ID), 
                'Parameter set for adhoc query dependency process',
                @CHANGEAGENTID,
                @CHANGEAGENTID)

    return 0;

end