UFN_EVENTCONFLICT_GETLOCATIONNAME

This function returns the location names for an event conflict.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTCONFLICT_GETLOCATIONNAME
            (
                @ID    uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @LOCATIONS nvarchar(500);
                declare @ORDEREDLOCATIONS table (NAME nvarchar(100));

                insert into @ORDEREDLOCATIONS
                    select EVENTLOCATION.NAME
                    from dbo.PROGRAMEVENTLOCATION
                    inner join dbo.EVENTLOCATION on EVENTLOCATION.ID = PROGRAMEVENTLOCATION.EVENTLOCATIONID
                    where PROGRAMEVENTLOCATION.EVENTCONFLICTID = @ID
                    order by PROGRAMEVENTLOCATION.SEQUENCE;

                select @LOCATIONS = dbo.UDA_BUILDLIST(NAME) 
                from @ORDEREDLOCATIONS;

                return @LOCATIONS; 
            end