UFN_FUNDINGREQUEST_DESIGNATIONS

Returns the participants for a request.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_FUNDINGREQUEST_DESIGNATIONS
            (
                @FUNDINGREQUESTID uniqueidentifier
            ) 
            returns table
            as 
            return
                select                
                    FUNDINGREQUESTDESIGNATION.ID, 
                    FUNDINGREQUESTDESIGNATION.DESIGNATIONID,
                    FUNDINGREQUESTDESIGNATION.SEQUENCE
                from 
                    dbo.FUNDINGREQUESTDESIGNATION
                where 
                    FUNDINGREQUESTDESIGNATION.FUNDINGREQUESTID = @FUNDINGREQUESTID;