UFN_PROGRAM_ADDLOCATIONS

Generates locations functions for program.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_PROGRAM_ADDLOCATIONS
       (
          @PROGRAMID uniqueidentifier
        )
        returns table
        as return
            select
                PROGRAMLOCATION.ID,
                PROGRAMLOCATION.EVENTLOCATIONID,
                EVENTLOCATION.CAPACITY
            from
                dbo.PROGRAMLOCATION
            inner join 
                dbo.EVENTLOCATION on PROGRAMLOCATION.EVENTLOCATIONID=EVENTLOCATION.ID
            where
                PROGRAMLOCATION.PROGRAMID=@PROGRAMID;