USP_REPORT_VSESECONDARY_SECTION4B_PART1

            CREATE procedure dbo.USP_REPORT_VSESECONDARY_SECTION4B_PART1
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @INCLUDEINACTIVE smallint = 0,
                @INCLUDEDECEASED smallint = 0,
                @USEGIFTDATE smallint = 0
            )
            with execute as caller
            as
                select
                    REPORT_VSESECONDARY.VSECONSTITUENCYCODE,
                    REPORT_VSESECONDARY.LABEL,
                    sum(coalesce(REPORT_VSESECONDARY.NUMSOLICIT, 0)) as NUMBER_SOLICITED, 
                    sum(coalesce(REPORT_VSESECONDARY.NUMDONOR, 0)) as NUMBER_DONORS,
                    sum(coalesce(REPORT_VSESECONDARY.TOTAMT, 0)) as TOTAL_AMOUNT
                from
                    (
                    select 
                        case
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 0 then 1
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 5 then 2
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 6 then 3
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 7 then 4
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 8 then 5
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 9 then 6
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 10 then 7
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 11 then 7
                            else VSECONSTITUENCY.VSECONSTITUENCYCODE
                        end as VSECONSTITUENCYCODE,
                        case
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 0 then '1. Alumni'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 5 then '2a. Current Parents'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 6 then '2b. Past Parents'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 7 then '3. Grandparents'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 8 then '4. Faculty and Staff'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 9 then '5. Students'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 10 then '6. Other Individuals'
                            when VSECONSTITUENCY.VSECONSTITUENCYCODE = 11 then '6. Other Individuals'
                        end as LABEL,
                        VSECNTS.NUMSOLICIT, 
                        V2.NUMDONOR,
                        V2.TOTAMT
                    from 
                        dbo.VSECONSTITUENCY
                        left outer join 
                        (
                            select
                                count(distinct REPORT_VSESECONDARY.CONSTITUENTID) as NUMDONOR,
                                sum(REPORT_VSESECONDARY.REVENUESPLITAMOUNT) as TOTAMT,
                                REPORT_VSESECONDARY.VSECONSTITUENCYCODE,
                                null as PROGRAMCODE
                            from
                                dbo.UFN_REPORT_VSESECONDARY(@STARTDATE, @ENDDATE, @INCLUDEINACTIVE, @INCLUDEDECEASED, @USEGIFTDATE) as REPORT_VSESECONDARY
                            where
                                REPORT_VSESECONDARY.VSECATEGORYPURPOSETYPECODE = 0
                                and REPORT_VSESECONDARY.VSECONSTITUENTTYPECODE = 0
                            group by REPORT_VSESECONDARY.VSECONSTITUENCYCODE
                        ) V2 on V2.vseconstituencycode = VSECONSTITUENCY.VSECONSTITUENCYCODE
                        left outer join dbo.UFN_REPORT_VSECOUNTS(@STARTDATE, @ENDDATE, @INCLUDEINACTIVE, @INCLUDEDECEASED, 0) VSECNTS 
                            on VSECNTS.VSECONSTITUENCYCODE = VSECONSTITUENCY.VSECONSTITUENCYCODE 
                    where
                        VSECONSTITUENCY.USAGETYPECODE <> 0
                        and VSECONSTITUENCY.TYPECODE = 0
                    union all
                    select 1, '1. Alumni', 0, 0, 0ODE
                    ) REPORT_VSESECONDARY
                group by VSECONSTITUENCYCODE, LABEL