USP_PATTERNBLOCK_DELETE_BYMEETING

Executes the "Delete pattern block meetings (Wrapped)" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



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

                set nocount on

                declare @PATTERNBLOCKID uniqueidentifier
                select @PATTERNBLOCKID = PATTERNBLOCKID
                from
                    PATTERNBLOCKMEETING
                where
                    ID = @ID

                /* invoke the default implementation */
                declare @r int
                exec @r = dbo.USP_PATTERNBLOCK_DELETE 
                  @ID = @PATTERNBLOCKID, 
                  @CHANGEAGENTID = @CHANGEAGENTID

                if @@error <> 0 
                    begin
                        if @r <> 0 return @r
                        return 1
                    end

                return @r