UPDATE #Request.prefix_db_lookup#.meds_pathway_lookup SET Approved = WHERE ID IN () UPDATE #Request.prefix_db_lookup#.Meds_New SET Classification = WHERE Trade_Num = UPDATE #Request.prefix_db_lookup#.pPathway SET Approved = WHERE ID IN () UPDATE #Request.prefix_db_lookup#.pPathway SET Approved = WHERE ID IN () UPDATE #Request.prefix_db_agency#.pAdmit SET Approved = WHERE AutoAdmit_ID IN ()