INSERT IGNORE INTO #Request.prefix_db_agency#.pPtPayer ( Patient_ID,Status,Payer_ID,Date_Create,Created_by,Date_Change,Change_by ) VALUES ( , , , , , , ) SELECT LAST_INSERT_ID() as PtPayer_ID INSERT IGNORE INTO #Request.prefix_db_agency#.pAdmit ( Patient_ID,Status,Date_Create,Created_by,Date_Change,Change_by ) VALUES ( , , , , , ) INSERT IGNORE INTO #Request.prefix_db_agency#.pAssessments ( Patient_ID,Loc_ID,Deleted,Date_Create,Created_by,Date_Change,Change_by ) VALUES ( , , , , , , ) SELECT LAST_INSERT_ID() as Assmt_ID INSERT IGNORE INTO #Request.prefix_db_agency#.pAuth ( Patient_ID,Assess_ID,PtPayer_ID,Status,Skill,Total_Visits,Date_Create,Created_by,Date_Change,Change_by ) VALUES ( , , , , , , , , , ) SELECT LAST_INSERT_ID() as Auth_ID INSERT IGNORE INTO #Request.prefix_db_agency#.pSchedule ( Patient_ID, Auth_ID, PtPayer_ID, Pay_ID,Status, Skill, Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , )