USP_DATALIST_CONSTITUENT_LAST10GIFTS

                CREATE procedure dbo.USP_DATALIST_CONSTITUENT_LAST10GIFTS(@CONSTITUENTID uniqueidentifier, @INCLUDESOFTCREDIT bit = 0)
                as
                    set nocount on;

                    select distinct top 10
                        R.ID,
                        R.ID as RECORDID,
                        R.DATE,
                        R.DATEADDED,
                        R.AMOUNT,
                        case R.TRANSACTIONTYPECODE when 1 then dbo.UFN_PLEDGE_GETBALANCE(R.ID) else null end as BALANCE,
                        R.TRANSACTIONTYPECODE,
                        R.TRANSACTIONTYPE as TYPE,
                        dbo.UFN_REVENUE_DESIGNATIONLIST(R.ID) as DESIGNATION
                    from
                        dbo.REVENUE R
                    where
                        ((R.TRANSACTIONTYPECODE = 1) or --Pledge

                         (R.TRANSACTIONTYPECODE = 7) or --Auction donation

                        ((R.TRANSACTIONTYPECODE = 0) and exists(select top 1 ID from REVENUESPLIT where REVENUEID = R.ID and APPLICATIONCODE in (0, 3)))) and --Payment (Gift or Recurring gift payment)

                        R.CONSTITUENTID = @CONSTITUENTID
                    order by
                        R.DATE desc, R.DATEADDED desc, R.AMOUNT desc;