USP_EXCHANGECALENDARSYNC_GETSTEWARDSHIPCALENDARINFORMATION

CREATE procedure dbo.USP_EXCHANGECALENDARSYNC_GETSTEWARDSHIPCALENDARINFORMATION
(
    @STEPID uniqueidentifier
)
as
    set nocount on;

    select 
        STEWARDSHIPPLANSTEP.ID, 
        OBJECTIVE as SUBJECT, 
        TARGETDATE,
        CONSTITUENT.NAME as CONSTITUENTNAME, 
        STEWARDSHIPPLANSTEP.TARGETSTARTDATETIME,
        STEWARDSHIPPLANSTEP.TARGETENDDATETIME,
        TIMEZONEENTRYID,
        (select TIMEZONEENTRY.NAME from dbo.TIMEZONEENTRY where TIMEZONEENTRY.ID = STEWARDSHIPPLANSTEP.TIMEZONEENTRYID) as TIMEZONE,
        STEWARDSHIPPLANSTEP.ISALLDAYEVENT
    from
        dbo.STEWARDSHIPPLANSTEP
    inner join dbo.STEWARDSHIPPLAN 
        on STEWARDSHIPPLAN.ID = STEWARDSHIPPLANSTEP.PLANID
    inner join dbo.CONSTITUENT
        on CONSTITUENT.ID = STEWARDSHIPPLAN.CONSTITUENTID
    where
        STEWARDSHIPPLANSTEP.ID = @STEPID;