USP_REPORT_DASHBOARD_ACTIVEMEMBERSHIPS_COUNT

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

          begin            

            set @TODATE = dbo.UFN_DATE_GETLATESTTIME(@TODATE);

            select 
                COUNT(distinct MEMBERSHIP.ID) [count]
            from
                dbo.MEMBERSHIP
            where
                MEMBERSHIP.STATUSCODE = 0
        end