SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE V_TestHHASchedule(
   Schedule_ScheduleID          VARCHAR(20)
  ,Patients_FirstName           VARCHAR(20)
  ,Patients_LastName            VARCHAR(19)
  ,Caregivers_FirstName         VARCHAR(22)
  ,Caregivers_LastName          VARCHAR(21)
  ,Caregivers_Gender            VARCHAR(19)
  ,Caregivers_TimeAttendancePIN VARCHAR(30)
  ,Schedule_VisitDate           date
  ,Schedule_ScheduleStartTime   datetime
  ,Schedule_ScheduleEndTime     datetime
  ,Schedule_VisitStartTime      datetime
  ,Schedule_VisitEndTime        datetime
  ,Schedule_IsDeleted           VARCHAR(20)
  ,Patients_AdmissionID         VARCHAR(22)
  ,Schedule_PatientID           VARCHAR(20)
  ,Schedule_CaregiverID         VARCHAR(22)
  ,Patients_TeamID              VARCHAR(17)
  ,FIELD18                      VARCHAR(30)
);
INSERT INTO V_TestHHASchedule(Schedule_ScheduleID,Patients_FirstName,Patients_LastName,Caregivers_FirstName,Caregivers_LastName,Caregivers_Gender,Caregivers_TimeAttendancePIN,Schedule_VisitDate,Schedule_ScheduleStartTime,Schedule_ScheduleEndTime,Schedule_VisitStartTime,Schedule_VisitEndTime,Schedule_IsDeleted,Patients_AdmissionID,Schedule_PatientID,Schedule_CaregiverID,Patients_TeamID) 
VALUES (NULL,'test first p','test last p','test c first','test c last',NULL,NULL,'2018-11-19 00:00',NULL,NULL,'11/19/2018  14:59:00 PM','11/19/2018  23:04:00 PM',NULL,NULL,NULL,NULL,NULL);
1 rows affected

CREATE TABLE VisitReport(
   RowID           INTEGER 
  ,AltPatientID    VARCHAR(14)
  ,MedicaidNo      VARCHAR(12)
  ,PatientName     VARCHAR(38)
  ,AideName        VARCHAR(34)
  ,CoordinatorName VARCHAR(17)
  ,VisitDate       VARCHAR(11)
  ,ScheduleTime    VARCHAR(14)
  ,VisitTime       VARCHAR(11)
  ,Duration        VARCHAR(10)
  ,ContractName    VARCHAR(14)
  ,ServiceCode_1   VARCHAR(15)
  ,PayrateCode     VARCHAR(13)
  ,PayRate         VARCHAR(9)
  ,Discipline      VARCHAR(12)
  ,Billed          VARCHAR(8)
  ,InvoiceNum      VARCHAR(12)
  ,InvoiceDate     VARCHAR(13)
  ,TS              VARCHAR(4)
  ,TotalHrs        VARCHAR(10)
  ,TotalDuration   VARCHAR(15)
  ,Field22         VARCHAR(9)
  ,FIELD24         VARCHAR(30)
);
INSERT INTO VisitReport(RowID,AltPatientID,MedicaidNo,PatientName,AideName,CoordinatorName,VisitDate,ScheduleTime,VisitTime,Duration,ContractName,ServiceCode_1,PayrateCode,PayRate,Discipline,Billed,InvoiceNum,InvoiceDate,TS,TotalHrs,TotalDuration,Field22) VALUES (1,NULL,NULL,'test last p  test first p (WW-21345)','test c last test c first (11710)',NULL,'19-Nov-18',NULL,'1459-2304','08:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1 rows affected

SELECT 

  replace(convert(varchar(19),Schedule_VisitStartTime,6),':','') 
  
  , replace(convert(varchar(5),Schedule_VisitStartTime,108),':','')
  + '-'
  + replace(convert(varchar(5),Schedule_VisitEndTime,108),':','')
from V_TestHHASchedule


(No column name)
(No column name)


19 Nov 18
1459-2304


SELECT
    Patients_LastName + ' ' + Patients_FirstName     AS PatientName
  , Caregivers_LastName + ' ' + Caregivers_FirstName AS AideName
  , replace(convert(varchar(11),Schedule_VisitDate,6),' ','-')  AS VisitDate
  , replace(convert(varchar(5),Schedule_VisitStartTime,108),':','')
  + '-'
  + replace(convert(varchar(5),Schedule_VisitEndTime,108),':','')
  as VisitTime
FROM V_TestHHASchedule


PatientName
AideName
VisitDate
VisitTime


test last p test first p
test c last test c first
19-Nov-18
1459-2304


SELECT
    RTRIM( LEFT( PatientName, CHARINDEX( ' (', PatientName + ' (' ) ) )
  , RTRIM( LEFT( AideName, CHARINDEX( ' (', AideName + ' (' ) ) )
  , VisitDate
  , VisitTime
FROM VisitReport


(No column name)
(No column name)
VisitDate
VisitTime


test last p  test first p
test c last test c first
19-Nov-18
1459-2304


SELECT
    v.Patients_LastName + ' ' + v.Patients_FirstName     AS PatientName
  , v.Caregivers_LastName + ' ' + v.Caregivers_FirstName AS AideName
  , replace(convert(varchar(11),v.Schedule_VisitDate,6),' ','-')  AS VisitDate
  , replace(convert(varchar(5),v.Schedule_VisitStartTime,108),':','')
  + '-'
  + replace(convert(varchar(5),v.Schedule_VisitEndTime,108),':','')
  as VisitTime
FROM V_TestHHASchedule v

except

SELECT
    replace(RTRIM( LEFT( PatientName, CHARINDEX( ' (', PatientName + ' (' ) ) ),'  ',' ')
  , replace(RTRIM( LEFT( AideName, CHARINDEX( ' (', AideName + ' (' ) ) ),'  ',' ')
  , VisitDate
  , VisitTime
FROM VisitReport


PatientName
AideName
VisitDate
VisitTime


SELECT DISTINCT
    REPLACE( CONVERT( varchar(5), V.Schedule_ScheduleStartTime, 108 ) + '-' + CONVERT( varchar(5), V.Schedule_ScheduleEndTime, 108 ), ':', '' ) sched
   , v.*
FROM [V_TestHHASchedule] AS V
WHERE EXISTS (
    SELECT
        NULL
    FROM [VisitReport] R
    WHERE ( v.Patients_LastName + ' ' + v.Patients_FirstName )               = ( replace(RTRIM( LEFT( r.PatientName, CHARINDEX( ' (', r.PatientName + ' (' ) ) ),'  ',' ') )
    AND ( v.Caregivers_LastName + ' ' + v.Caregivers_FirstName )             = ( replace(RTRIM( LEFT( r.AideName, CHARINDEX( ' (', r.AideName + ' (' ) ) ),'  ',' ') )
    AND ( replace(convert(varchar(11),v.Schedule_VisitDate,6),' ','-') )     = r.VisitDate
    AND ( replace(convert(varchar(5),v.Schedule_VisitStartTime,108),':','')
          + '-'
          + replace(convert(varchar(5),v.Schedule_VisitEndTime,108),':','')) = r.VisitTime
    )


sched
Schedule_ScheduleID
Patients_FirstName
Patients_LastName
Caregivers_FirstName
Caregivers_LastName
Caregivers_Gender
Caregivers_TimeAttendancePIN
Schedule_VisitDate
Schedule_ScheduleStartTime
Schedule_ScheduleEndTime
Schedule_VisitStartTime
Schedule_VisitEndTime
Schedule_IsDeleted
Patients_AdmissionID
Schedule_PatientID
Schedule_CaregiverID
Patients_TeamID
FIELD18


null
null
test first p
test last p
test c first
test c last
null
null
19/11/2018 00:00:00
null
null
19/11/2018 14:59:00
19/11/2018 23:04:00
null
null
null
null
null
null


SELECT DISTINCT
    REPLACE( CONVERT( varchar(5), V.Schedule_ScheduleStartTime, 108 ) + '-' + CONVERT( varchar(5), V.Schedule_ScheduleEndTime, 108 ), ':', '' ) sched
   , v.*
FROM [V_TestHHASchedule] AS V
WHERE NOT EXISTS (
    SELECT
        NULL
    FROM [VisitReport] R
    WHERE ( v.Patients_LastName + ' ' + v.Patients_FirstName )               = ( replace(RTRIM( LEFT( r.PatientName, CHARINDEX( ' (', r.PatientName + ' (' ) ) ),'  ',' ') )
    AND ( v.Caregivers_LastName + ' ' + v.Caregivers_FirstName )             = ( replace(RTRIM( LEFT( r.AideName, CHARINDEX( ' (', r.AideName + ' (' ) ) ),'  ',' ') )
    AND ( replace(convert(varchar(11),v.Schedule_VisitDate,6),' ','-') )     = r.VisitDate
    AND ( replace(convert(varchar(5),v.Schedule_VisitStartTime,108),':','')
          + '-'
          + replace(convert(varchar(5),v.Schedule_VisitEndTime,108),':','')) = r.VisitTime
    )


sched
Schedule_ScheduleID
Patients_FirstName
Patients_LastName
Caregivers_FirstName
Caregivers_LastName
Caregivers_Gender
Caregivers_TimeAttendancePIN
Schedule_VisitDate
Schedule_ScheduleStartTime
Schedule_ScheduleEndTime
Schedule_VisitStartTime
Schedule_VisitEndTime
Schedule_IsDeleted
Patients_AdmissionID
Schedule_PatientID
Schedule_CaregiverID
Patients_TeamID
FIELD18