USP_DATALIST_RECENTLARGEGIFTS_FORCONSTITUENT

Returns a list of recent, large revenue records for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@MAXROWS	int	IN	Input parameter indicating the maximum number of rows to return.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DATAWINDOWOPEN	date	IN	Beginning
@DATAWINDOWCLOSE	date	IN	Ending
@LARGEAMOUNT	money	IN	Show gifts larger than

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECENTLARGEGIFTS_FORCONSTITUENT
                (
                    @MAXROWS int = null,
                    @CONSTITUENTID uniqueidentifier,
                    @DATAWINDOWOPEN date = null,
                    @DATAWINDOWCLOSE date = null,
                    @LARGEAMOUNT money
                )
                as
                set nocount on;

                select top(coalesce(@MAXROWS,500))
                    FINANCIALTRANSACTION.ID,
                    FINANCIALTRANSACTION.ORGAMOUNT as ORGANIZATIONAMOUNT,
                    FINANCIALTRANSACTION.DATE,
                    FINANCIALTRANSACTION.TYPE as TRANSACTIONTYPE,
                    CONSTITUENT.NAME
                from dbo.FINANCIALTRANSACTION
                inner join dbo.CONSTITUENT on CONSTITUENT.ID = FINANCIALTRANSACTION.CONSTITUENTID
                where FINANCIALTRANSACTION.ORGAMOUNT >= @LARGEAMOUNT
                    and FINANCIALTRANSACTION.CONSTITUENTID = @CONSTITUENTID
                    and ((@DATAWINDOWOPEN is null or @DATAWINDOWCLOSE is null) or (FINANCIALTRANSACTION.DATE between @DATAWINDOWOPEN and @DATAWINDOWCLOSE))
                order by CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, FINANCIALTRANSACTION.ORGAMOUNT, FINANCIALTRANSACTION.DATE