UFN_EVENT_CANSUPPORTEVENTS

Validates that the supporting event is not a main event for other events. Main events cannot be supporting events.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@MAINEVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENT_CANSUPPORTEVENTS
            (
                @EVENTID uniqueidentifier = null,
                @MAINEVENTID uniqueidentifier = null                
            ) 
            returns bit with execute as caller
            as
            begin                
                if @MAINEVENTID is not null begin 
                    if exists(select ID from dbo.EVENT where EVENT.MAINEVENTID = @EVENTID) --An event with supporting events cannot support another event

                        return 0
                    else
                        return 1
                end 

                return 1
            end