SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agy_Mailing = '#email#' SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agy_Phone = '#phone#' SELECT State_ID,StateName, StateAbbr FROM #Request.prefix_db_lookup#.States ORDER BY StateName SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE status = AND Loc_ID = ORDER BY Phys_Last, Phys_First SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE status = AND Loc_ID = ORDER BY Emp_Last,Emp_First SELECT * FROM #Request.prefix_db_lookup#.messages WHERE form_type = AND deleted != 1 ORDER BY message_id SELECT * FROM #Request.prefix_db_lookup#.answer_lookup WHERE answer_label = AND form_type = AND deleted != 1 ORDER BY answer_order,answer_id #arguments.Body# UPDATE #Request.prefix_db_agency#.Communication SET status = , Comm_record_deleted = , Record_Mod_Date = , Record_Mod_By = WHERE Comm_ID = UPDATE #Request.prefix_db_agency#.Event SET status = , Record_Mod_Date = , Record_Mod_By = WHERE Event_ID = UPDATE #Request.prefix_db_agency#.pCMS4857 SET status = , Date_Change = , Change_by = WHERE Order_ID = SELECT Agency.* FROM #Request.prefix_db_lookup#.pEmployee JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pEmployee.Loc_ID AND Agency.Status = 'active' WHERE pEmployee.status = AND pEmployee.username = AND pEmployee.password = SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Loc_ID = AND Status = AND Phys_ID = AND Phys_Fax IS NOT NULL ORDER BY Phys_Last,Phys_First ASC