Access denied.

Append ?sec_key=yes_run_it_now to the URL to view the report (preview only).

Add &action=run to actually apply the update.

 SELECT agency_id, Agency_Login, Agency_Name FROM #Request.prefix_db_lookup#.Agency WHERE status = 'active' AND agency_id = ORDER BY agency_id SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = SELECT COUNT(*) AS cnt FROM #agencyDb#.pSchedules pSchedules JOIN #agencyDb#.pAuths pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID AND pAuths.Assmt_ID <> pSchedules.Assmt_ID AND pAuths.Assmt_ID <> 0 AND pAuths.status = 0 AND pSchedules.status = 0 AND pSchedules.Invoice_ID = 0 SELECT pSchedules.Schedule_ID, pSchedules.Patient_ID, pSchedules.Visit_Date, pSchedules.Auth_ID, pSchedules.Assmt_ID AS schedule_assmt, pAuths.Assmt_ID AS auth_assmt FROM #agencyDb#.pSchedules pSchedules JOIN #agencyDb#.pAuths pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID AND pAuths.Assmt_ID <> pSchedules.Assmt_ID AND pAuths.Assmt_ID <> 0 AND pAuths.status = 0 AND pSchedules.status = 0 AND pSchedules.Invoice_ID = 0 ORDER BY pSchedules.Visit_Date DESC UPDATE #agencyDb#.pSchedules pSchedules JOIN #agencyDb#.pAuths pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID AND pAuths.Assmt_ID <> pSchedules.Assmt_ID AND pAuths.Assmt_ID <> 0 AND pAuths.status = 0 AND pSchedules.status = 0 AND pSchedules.Invoice_ID = 0 SET pSchedules.Assmt_ID = pAuths.Assmt_ID Fix pSchedules.Assmt_ID from pAuths.Assmt_ID

Fix pSchedules.Assmt_ID ← pAuths.Assmt_ID

Mode: RUN (updates applied) PREVIEW (no changes made)
Agency scope: Agency_ID = #val(url.Agency_ID)# All active agencies (#Agencylist.recordCount# total)
Schedules that were updatedwould be updated: #totalFixed##totalToFix#
To apply, append &action=run to the URL.

Per-agency summary

Agency ID Agency Name Rows updatedto fix Status
#row.agency_id# #row.agency_name# #row.fixed##row.to_fix# #row.status# #row.status# #row.status#

Sample rows (up to #sampleLimit# per agency)

Agency Schedule_ID Patient_ID Visit Date Auth_ID Schedule.Assmt_ID Auth.Assmt_ID (new value)
#s.agency_id# #s.schedule_id# #s.patient_id# #DateFormat(s.visit_date,"mm/dd/yyyy")# #s.auth_id# #s.schedule_assmt# #s.auth_assmt#