USP_DATALIST_RESEARCHGROUPMEMBERGIVINGSUMMARY

List of giving summary information for members of a research group.

Parameters

Parameter	Parameter Type	Mode	Description
@RESEARCHGROUPID	uniqueidentifier	IN	Research Group ID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_RESEARCHGROUPMEMBERGIVINGSUMMARY
(
    @RESEARCHGROUPID uniqueidentifier
)
as
    set nocount on;

    select 
        RE7INTEGRATIONGIVINGSUMMARY.ID,
        RE7INTEGRATIONGIVINGSUMMARY.TOTALGIFTAMOUNT,
        RE7INTEGRATIONGIVINGSUMMARY.TOTALGIFTSGIVEN,
        RE7INTEGRATIONGIVINGSUMMARY.FIRSTGIFTAMOUNT,
        RE7INTEGRATIONGIVINGSUMMARY.FIRSTGIFTDATE,
        RE7INTEGRATIONGIVINGSUMMARY.FIRSTGIFTTYPE,
        RE7INTEGRATIONGIVINGSUMMARY.FIRSTGIFTDESIGNATION,
        RE7INTEGRATIONGIVINGSUMMARY.LARGESTGIFTAMOUNT,
        RE7INTEGRATIONGIVINGSUMMARY.LARGESTGIFTDATE,
        RE7INTEGRATIONGIVINGSUMMARY.LARGESTGIFTTYPE,
        RE7INTEGRATIONGIVINGSUMMARY.LARGESTGIFTDESIGNATION,
        RE7INTEGRATIONGIVINGSUMMARY.LATESTGIFTAMOUNT,
        RE7INTEGRATIONGIVINGSUMMARY.LATESTGIFTDATE,
        RE7INTEGRATIONGIVINGSUMMARY.LATESTGIFTTYPE,
        RE7INTEGRATIONGIVINGSUMMARY.LATESTGIFTDESIGNATION
    from 
        dbo.RESEARCHGROUPMEMBER
        left join dbo.RE7INTEGRATIONGIVINGSUMMARY on RESEARCHGROUPMEMBER.CONSTITUENTID = RE7INTEGRATIONGIVINGSUMMARY.ID
    where RESEARCHGROUPMEMBER.RESEARCHGROUPID = @RESEARCHGROUPID