UFN_TIMETABLEDAY_GETTIMETABLEDAYPERIODS

CREATE function dbo.UFN_TIMETABLEDAY_GETTIMETABLEDAYPERIODS( @TIMETABLEDAYID uniqueidentifier )
returns table
as return(

    select 
        ID,
        PERIOD,
        DESCRIPTION,
        STARTTIME,
        ENDTIME,
        case when exists(
                select 1
                from dbo.CLASSMEETINGTEMPLATE
                where TIMETABLEDAYPERIOD.ID = CLASSMEETINGTEMPLATE.TIMETABLEDAYPERIODID
                ) then 1 else 0 end as INUSE
    from
        dbo.TIMETABLEDAYPERIOD

    where 
        TIMETABLEDAYID = @TIMETABLEDAYID

    )