USP_DATALIST_FUNDINGREQUESTDESIGNATIONS

Returns a list of designations used by a funding request.

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_FUNDINGREQUESTDESIGNATIONS
                (
                    @FUNDINGREQUESTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        FUNDINGREQUESTDESIGNATION.ID,
                        DESIGNATION.NAME,
                        FUNDINGREQUESTDESIGNATION.DESIGNATIONID
                    from 
                        dbo.FUNDINGREQUESTDESIGNATION
                        inner join dbo.DESIGNATION on DESIGNATION.ID = FUNDINGREQUESTDESIGNATION.DESIGNATIONID
                    where 
                        FUNDINGREQUESTID = @FUNDINGREQUESTID