USP_REPORT_DASHBOARD_ACTIVEMEMBERSHIPS_BYLEVEL

        create procedure dbo.USP_REPORT_DASHBOARD_ACTIVEMEMBERSHIPS_BYLEVEL
        (            
            @TODATE datetime = null
        )
        as
          set nocount on;

          begin

            set @TODATE = dbo.UFN_DATE_GETLATESTTIME(@TODATE)            

            select 
                MEMBERSHIPPROGRAM.NAME ProgramName,
                MEMBERSHIPLEVEL.NAME LevelName,
                COUNT(distinct MEMBERSHIP.ID) [count]
            from
                dbo.MEMBERSHIP
                inner join dbo.MEMBERSHIPPROGRAM on
                    MEMBERSHIP.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                inner join dbo.MEMBERSHIPLEVEL on
                    MEMBERSHIP.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
            where
                MEMBERSHIP.STATUSCODE = 0
            group by
                MEMBERSHIPPROGRAM.NAME,
                MEMBERSHIPLEVEL.NAME
            order by
                3 desc, 1, 2
        end