SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle, Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = SELECT assN.Certification_Start, assN.Certification_End FROM #Request.prefix_db_agency#.Assessment_New assN WHERE assN.Assessment_Tracker_ID = SELECT (pvd.Reading1/65)*100 as Reading1, si.Visit_Date FROM #Request.prefix_db_agency#.PatientVisitDetails pvd LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New assN on assN.Assessment_Tracker_ID = pvd.Assessment_Tracker_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on si.Scheduleitems_ID = pvd.Scheduleitems_ID WHERE pvd.Patient_ID = AND pvd.Assessment_Tracker_ID = AND pvd.description = 'BP Diastolic' AND si.Visit_Date between assN.Certification_Start and assN.Certification_End ORDER by si.Visit_Date SELECT (pvd.Reading1/110)*100 as Reading1, si.Visit_Date FROM #Request.prefix_db_agency#.PatientVisitDetails pvd LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New assN on assN.Assessment_Tracker_ID = pvd.Assessment_Tracker_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on si.Scheduleitems_ID = pvd.Scheduleitems_ID WHERE pvd.Patient_ID = AND pvd.Assessment_Tracker_ID = AND pvd.description = 'BP Systolic' AND si.Visit_Date between assN.Certification_Start and assN.Certification_End ORDER by si.Visit_Date SELECT (pvd.Reading1/72)*100 as Reading1, si.Visit_Date FROM #Request.prefix_db_agency#.PatientVisitDetails pvd LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New assN on assN.Assessment_Tracker_ID = pvd.Assessment_Tracker_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on si.Scheduleitems_ID = pvd.Scheduleitems_ID WHERE pvd.Patient_ID = AND pvd.Assessment_Tracker_ID = AND pvd.description = 'Heart Rate' AND si.Visit_Date between assN.Certification_Start and assN.Certification_End ORDER by si.Visit_Date