UFN_PROGRAMLOCATION_GETLOCATIONS

Retrieves locations that belong to a program

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_PROGRAMLOCATION_GETLOCATIONS
    (
      @PROGRAMID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        EVENTLOCATIONID,
        ISDEFAULT
            from
                dbo.PROGRAMLOCATION
            where
                PROGRAMID=@PROGRAMID;