USP_REPORT_DESIGNATIONLEVELPROFILESUMMARY

            CREATE proc dbo.USP_REPORT_DESIGNATIONLEVELPROFILESUMMARY(@DESIGNATIONLEVELID uniqueidentifier, @CURRENCYCODE tinyint = 1)
                as

                declare @ORGANIZATIONCURRENCYID uniqueidentifier;
                set @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                declare @SELECTEDCURRENCYID uniqueidentifier = null;

                --NOTE: if @CURRENCYCODE is 0 return in designation's Base currency, @SELECTEDCURRENCYID is null

                if @CURRENCYCODE <> 0
                    --return in Organization currency

                    set @SELECTEDCURRENCYID = @ORGANIZATIONCURRENCYID;
                else
                    select @SELECTEDCURRENCYID = BASECURRENCYID
                    from dbo.DESIGNATIONLEVEL
                    where ID = @DESIGNATIONLEVELID;

                declare @CURRENCYISO nvarchar(6);
                declare @CURRENCYDECIMALDIGITS tinyint;
                declare @CURRENCYSYMBOL nvarchar(10);
                declare @CURRENCYROUNDINGTYPECODE tinyint;
                declare @CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint;

                select
                        @CURRENCYISO = CURRENCY.ISO4217,
                        @CURRENCYDECIMALDIGITS = CURRENCY.DECIMALDIGITS,
                        @CURRENCYSYMBOL = CURRENCY.CURRENCYSYMBOL,
                        @CURRENCYROUNDINGTYPECODE = CURRENCY.ROUNDINGTYPECODE,
                        @CURRENCYSYMBOLDISPLAYSETTINGCODE = CURRENCY.SYMBOLDISPLAYSETTINGCODE
                 from dbo.CURRENCY
                where CURRENCY.ID = @SELECTEDCURRENCYID

                declare @TOTALRAISED money;     -- deprecated (replaced by total revenue)

                set @TOTALRAISED = 0;

                select
                    TOTALREVENUE,
                    NUMDONORS TOTALDONORS,
                    NUMGIFTS TOTALDONATIONS,
                    case NUMGIFTS when 0 then 0 else TOTALREVENUE / NUMGIFTS end as AVERAGEGIFT,
                    @CURRENCYISO CURRENCYISO,
                    @CURRENCYDECIMALDIGITS CURRENCYDECIMALDIGITS,
                    @CURRENCYSYMBOL CURRENCYSYMBOL,
                    @CURRENCYSYMBOLDISPLAYSETTINGCODE CURRENCYSYMBOLDISPLAYSETTINGCODE
                from
                    dbo.UFN_DESIGNATIONLEVEL_GETREVENUETOTALSINCURRENCY_2(@DESIGNATIONLEVELID, null, null, @SELECTEDCURRENCYID, @ORGANIZATIONCURRENCYID, @CURRENCYDECIMALDIGITS, @CURRENCYROUNDINGTYPECODE)