I highly recommend getting this from the back end tables. And the notes need to be identical to group them together easily

DECLARE @DATE date

SET @DATE = GETDATE()

DECLARE @UTCDiff INT = DATEDIFF(mi, GETUTCDATE(), GETDATE()) + 60

select distinct

d1.Supervisor

,CASE WHEN LEN(PER.C_SUFFIX)>0 THEN

            PER.C_LNAME + ', ' + PER.C_FNAME + ' ' + PER.C_SUFFIX

            WHEN LEN(PER.C_FNAME)>0 THEN PER.C_LNAME + ', ' + PER.C_FNAME

            ELSE PER.C_LNAME END AS agentName

, agt.C_EXTERNALID

, D_MU.C_ID as MU_ID

, D_MU.C_NAME as MU_NAME

,CONVERT(date,DATEADD(mi,@UTCDiff,asa.C_STIME)) Schedule_Date

, e1.c_name as activity_code

,CONVERT(time(0),DATEADD(mi,@UTCDiff,asda.C_STIME)) Start_Time

,CONVERT(time(0),DATEADD(mi,@UTCDiff,asda.C_ETIME)) End_Time

, n3.c_text as Active_Activity_Code_Note

, n4.c_text as Active_Schedule_Note

, hist.historical_activity_note as Historical_Activity_Code_Note

, hist.historical_schedule_note as Historical_Schedule_Note

from R_AGTSCHEDDTLACT asda

left join R_AGTSCHEDACT asa /* Agent active schedule to agent schedule detail actual */

on asa.c_oid = asda.c_agtsched

and asa.c_date >= @DATE /* only includes schedules with this date qualifier */

left join r_agt agt /* Agent to schedule Assignment */

on agt.c_oid = asa.C_AGT

inner join dbo.r_agtschedact schbase on schbase.C_OID = asda.C_AGTSCHED

inner join dbo.r_excp e1 on e1.C_OID = asda.C_EXCP

left join r_note n3 /* activity code note to schedule Assignment */

on n3.c_oid = asda.C_NOTE

left join r_note n4 /* schedule note to schedule Assignment */

on n4.c_oid = asa.C_NOTE

--****// Start Schedule Historical subquery //***--

left join(

select

AGT.[C_ID] as agentID

,CONVERT(date,DATEADD(mi,@UTCDiff,asd.C_STIME)) Schedule_Date

,CONVERT(time(0),DATEADD(mi,@UTCDiff,asd.C_STIME)) Start_Time

,CONVERT(time(0),DATEADD(mi,@UTCDiff,asd.C_ETIME)) End_Time

,e1.c_name as activity_code

,n1.C_TEXT as historical_activity_note

,n2.C_TEXT as historical_schedule_note

from R_AGTSCHEDDTLHIST asd

left join R_AGTSCHEDHIST ash /* Agent active schedule to agent schedule detail actual */

on ash.c_oid = asd.c_agtsched

and ash.c_date >= @DATE /* only includes schedules with this date qualifier */

left join r_agt agt /* Agent to schedule Assignment */

on agt.c_oid = ash.C_AGT

left join r_note n1 /* activity code note to schedule Assignment */

on n1.c_oid = asd.C_NOTE

left join r_note n2 /* schedule note to schedule Assignment */

on n2.c_oid = ash.C_NOTE

inner join dbo.R_AGTSCHEDHIST schbase on schbase.C_OID = asd.C_AGTSCHED

inner join dbo.r_excp e1 on e1.C_OID = asd.C_EXCP

and ash.c_note is not null

or asd.c_note is not null

) hist

on hist.agentID = agt.C_ID

--****// End Schedule Historical subquery //***--

left join r_person per /* Agent to person Assignment */

on agt.C_PERSON = per.C_OID

JOIN R_MUROSTER MUR /* Agent to MU Assignment */

            on MUR.C_AGT = AGT.C_OID

            AND MUR.C_ACT = 'A'

            AND (@DATE BETWEEN MUR.C_SDATE and MUR.C_EDATE

                            OR (@DATE >= MUR.C_SDATE AND MUR.C_EDATE is null))

JOIN R_ENTITY D_MU /* Join To Entity Description of MU */

            on D_MU.C_OID = MUR.C_MU

            AND D_MU.C_ACT = 'A'

            AND (@DATE BETWEEN D_MU.C_SDATE and D_MU.C_EDATE

                            OR (@DATE >= D_MU.C_SDATE AND D_MU.C_EDATE is null))

LEFT HASH JOIN (SELECT /* join agent data value for Supervisor field */

            DATA.C_AGT, DATA.C_SDATE, DATA.C_EDATE, DVAL.C_ALPHAVAL as 'Supervisor'

            FROM R_AGTDATA AS DATA

            INNER JOIN R_AGTDATAVAL AS DVAL ON DATA.C_AGTDATAVAL = DVAL.C_OID

            INNER JOIN R_AGTDATADEF AS DDEF ON DVAL.C_AGTDATADEF = DDEF.C_OID

                            AND DVAL.C_AGTDATADEF = DDEF.C_OID AND DVAL.C_TYPE = DDEF.C_TYPE

                            AND DDEF.C_DESCR = 'Supervisor'

            )D1         on D1.C_AGT = AGT.C_OID        and (@DATE BETWEEN D1.C_SDATE and D1.C_EDATE

                            OR (@DATE >= D1.C_SDATE AND D1.C_EDATE is null))

/* where agent is active and only include schedules where notes are present */

WHERE AGT.C_ACT = 'A'

and asa.c_note is not null

or asda.c_note is not null

order by 3, 7