UPDATE #Request.prefix_db_lookup#.archive_pathway_details set Created_By = 0 where Created_by IS NULL UPDATE #Request.prefix_db_lookup#.archive_pathway_details set assessment_tracker_id=0 where assessment_tracker_id is null; select DISTINCT(a.Patient_ID) as id from #Request.prefix_db_lookup#.archive_assessments a where unarchive=1 order by Patient_ID; DELETE FROM #Request.prefix_db_lookup#.archive_assessments WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_forms WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_tracker WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_diagnosis WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_goals WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_pathway_details WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_patientvisitdetails WHERE Patient_ID = #pid# Deleted #pid#
select DISTINCT(a.Patient_ID) as id from #Request.prefix_db_lookup#.archive_assessments a where unarchive=0 order by Patient_ID; Unarchiving #pid#
select DISTINCT(p.Patient_ID) as pid from #Request.prefix_db_agency#.patient p where p.Status = 'deleted' order by Patient_ID Deleting deleted patient #pid#
DELETE FROM #Request.prefix_db_lookup#.archive_assessments WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_forms WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_tracker WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_diagnosis WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_goals WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_pathway_details WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_patientvisitdetails WHERE Patient_ID = #pid# SELECT distinct(a.patient_id) as pid FROM #Request.prefix_db_lookup#.archive_pathway_details a left outer join #Request.prefix_db_agency#.patient p on a.Patient_ID = p.Patient_ID where p.Status = 'active' or p.Status = 'inactive' order by a.Patient_ID Deleting active/inactive patient #pid#
DELETE FROM #Request.prefix_db_lookup#.archive_assessments WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_forms WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessment_tracker WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_diagnosis WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_goals WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_pathway_details WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_patientvisitdetails WHERE Patient_ID = #pid# DELETE FROM #Request.prefix_db_lookup#.archive_assessments WHERE Patient_ID IS NULL