USP_DATALIST_MEMBERSHIP_MEMBERSHIPRENEWALSBYDATE

            CREATE procedure dbo.USP_DATALIST_MEMBERSHIP_MEMBERSHIPRENEWALSBYDATE
            as
                set nocount on;

                select 
                    count(M.ID) as MEMBERSHIPS,
                    MP.NAME PROGRAM    
                from dbo.SALESORDERITEMMEMBERSHIP SOIM
                inner join dbo.MEMBERSHIP M on M.ID = SOIM.MEMBERSHIPID
                inner join dbo.MEMBERSHIPPROGRAM MP on M.MEMBERSHIPPROGRAMID = MP.ID
                inner join dbo.MEMBERSHIPTRANSACTION MT on MT.ID = SOIM.MEMBERSHIPTRANSACTIONID
                inner join dbo.SALESORDERITEM SOI on SOI.ID = SOIM.ID
                inner join dbo.SALESORDER SO on SO.ID = SOI.SALESORDERID
                where MT.ACTIONCODE = 1
                group by MP.NAME