USP_DATALIST_RECOGNITIONLEVELAMOUNTALL

Displays a list of revenue and planned gift amounts for a recognition level.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_RECOGNITIONLEVELAMOUNTALL(@RECOGNITIONLEVELID uniqueidentifier)
            as
                set nocount on;

                select ID,
                    AMOUNT,
                    PLANNEDGIFTAMOUNT,
                    ACTIVEDATE,
                    BASECURRENCYID
                from dbo.RECOGNITIONLEVELAMOUNT
                where RECOGNITIONLEVELID = @RECOGNITIONLEVELID
                order by ACTIVEDATE desc;