USP_ADHOCQUERY_DELETE

        create procedure dbo.USP_ADHOCQUERY_DELETE
            @ID uniqueidentifier,
            @APPUSERID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null
        with execute as caller
        as

        set nocount on;

        -- remove from ID Set register
        exec USP_IDSETREGISTER_DELETEFORADHOCQUERY @ID, @CHANGEAGENTID

        declare @R INT

        exec @R = dbo.USP_ADHOCQUERY_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID

        if @R <> 0 return @R

        return 0;