UFN_PATTERNBLOCKMEETINGS_INUSE

Returns true if the provided pattern has meetings being used on other records.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@PATTERNID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PATTERNBLOCKMEETINGS_INUSE
            (
                @PATTERNID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;

                    if exists 
                        (select * from dbo.PATTERNBLOCKMEETING 
                        inner join dbo.PATTERNBLOCK on PATTERNBLOCK.ID = PATTERNBLOCKMEETING.PATTERNBLOCKID
                        where PATTERNBLOCK.PATTERNID = @PATTERNID)
                        set @RETVAL = 1;

                return @RETVAL;
            end