UFN_TIXEVENT_GETLOCATIONNAME

This function returns the location names for an event.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_TIXEVENT_GETLOCATIONNAME
            (
                @ID    uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin

                declare @LOCATIONS nvarchar(500);

                select @LOCATIONS=dbo.UDA_BUILDLIST(NAME) 
                from dbo.EVENTLOCATION inner join dbo.TIXEVENTLOCATION on
                TIXEVENTLOCATION.EVENTLOCATIONID=EVENTLOCATION.ID  
                where TIXEVENTLOCATION.TIXEVENTID=@ID;

                return @LOCATIONS; 
            end