USP_DATALIST_MEMBERSHIPCONTRIBUTIONPROCESS_DEFAULT_SCHEDULE

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPCONTRIBUTIONPROCESS_DEFAULT_SCHEDULE
as
    set nocount on;
select 
    M.ID, 
    S.ID, 
    M.NAME, 
    S.ENABLED, 
    S.TYPE, 
    S.STARTDATE,
    S.TIME,
    S.ENDDATE,
    S.SUBDAYENDINGTIME,
    BPS.DATEADDED,
    BPS.DATECHANGED
from dbo.BUSINESSPROCESSSCHEDULE BPS
    inner join dbo.SCHEDULE S on BPS.SCHEDULEID = S.ID
    inner join dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS M on M.ID = BPS.BUSINESSPROCESSID 
where 
    BPS.BUSINESSPROCESSID =  'e2f6ff31-29ec-4480-b9a2-293c35fd2ca3'