UFN_PROGRAMS_GETLOCATIONS

Returns the default locations for the programs

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_PROGRAMS_GETLOCATIONS
        (
            @PROGRAMID uniqueidentifier
        )
        returns table
        as 
        return

            select 
                    EVENTLOCATION.ID as [LOCATIONID],
                    [NAME],
                    [CAPACITY]
                from 
                    dbo.EVENTLOCATION
                inner join dbo.PROGRAMLOCATION on
                    EVENTLOCATION.ID=PROGRAMLOCATION.EVENTLOCATIONID
                where PROGRAMLOCATION.PROGRAMID=@PROGRAMID;