INSERT IGNORE INTO #Request.prefix_db_agency#.pPatients
(
Agency_ID, Employee_ID,Status, Pt_Last, Pt_First,Record_Creation_Date,Record_Created_By,Record_Mod_Date, Record_Mod_By,cdate_cdarte
)
VALUES
(
,
,
,
,
,
,
,
,
,
)
SELECT LAST_INSERT_ID() as keyvalue
UPDATE #Request.prefix_db_agency#.pPatients SET
Agency_ID = ,
Employee_ID = ,
Status = ,
Pt_Last = ,
Pt_First = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Patient_ID =
