USP_DATALIST_MEMBERSHIPSTATUSUPDATE_DEFAULT_SCHEDULE

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPSTATUSUPDATE_DEFAULT_SCHEDULE
as
    set nocount on;


select 
    G.ID, 
    S.ID, 
    G.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.GLOBALCHANGE G on G.ID = BPS.BUSINESSPROCESSPARAMETERSETID
where 
    S.ID = 'D31014A5-7F9B-4440-9FF3-B15731CD8FF7'