UFN_GIVINGLEVELPROGRAMSITE_GETSITES

Returns all sites for a giving level program.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GIVINGLEVELPROGRAMID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_GIVINGLEVELPROGRAMSITE_GETSITES(@GIVINGLEVELPROGRAMID uniqueidentifier)
returns table
as return
            select
                ID,
        SITEID
            from
                dbo.GIVINGLEVELPROGRAMSITE
            where
                GIVINGLEVELPROGRAMID = @GIVINGLEVELPROGRAMID;