USP_DATALIST_GRANT

Returns a list of grants for a given grantor.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_GRANT
                    (
                        @ID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select distinct
                            GRANTS.ID,
                            GRANTS.TITLE,
                            isnull(sum(FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED),0),
                            isnull(sum(FUNDINGREQUEST.TRANSACTIONAMOUNTAWARDED), 0),
                            (select count(ID) from dbo.FUNDINGREQUEST where GRANTS.ID = FUNDINGREQUEST.GRANTSID),
                            GRANTS.TRANSACTIONCURRENCYID
                        from 
                            dbo.GRANTS
                            left join dbo.FUNDINGREQUEST on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                        where
                            GRANTS.GRANTORID = @ID
                        group by
                            GRANTS.ID, GRANTS.TITLE, GRANTS.TRANSACTIONCURRENCYID;