UFN_PROGRAM_GETLOCATIONNAME

This function returns the location names for a program.

Return

Return Type
nvarchar(1500)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROGRAM_GETLOCATIONNAME
            (
                @ID    uniqueidentifier
            )
            returns nvarchar(1500)
            with execute as caller
            as begin
                declare @LOCATIONS nvarchar(1500);
                declare @PROGRAMLOCATIONS table (NAME nvarchar(100));

                insert @PROGRAMLOCATIONS (NAME)
                select EVENTLOCATION.NAME
                from dbo.EVENTLOCATION
                inner join dbo.PROGRAMLOCATION on PROGRAMLOCATION.EVENTLOCATIONID = EVENTLOCATION.ID
                where PROGRAMLOCATION.PROGRAMID = @ID
                order by PROGRAMLOCATION.SEQUENCE;

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

                return @LOCATIONS;
            end