SELECT * FROM #Request.prefix_db_lookup#.Physician WHERE Employee_ID = 0 #Lastname#, #Firstname#
INSERT INTO #Request.prefix_db_lookup#.Employee (EmployeeType,Agency_ID,Last_name,First_Name,Address1,Address2,City,State,Zip,Home_Phone,Cell_Phone,Beeper,Email,status, Record_creation_Date, Record_created_By, Record_Mod_Date, Record_Mod_By) VALUES ('Physician',#agency_id#,'#lastname#','#firstname#','#address1#','#address2#','#city#','#state#','#zip#','#telephone1#','#cell#','#beeper#','#email#','#status#', #now()#, 0, #now()#, 0) SELECT MAX(Employee_ID) as maxid from #Request.prefix_db_lookup#.Employee Update #Request.prefix_db_lookup#.Physician set Employee_ID = #newvisit.maxid# where Physician_id = #physician_id#