insert into Provider (FirstName, MiddleName, LastName, Role, FullName) Values

('First1', 'Middle1', 'Last1', 'FC', 'Last1, First1 Middle1'),
('First2', 'Middle2', 'Last2', 'FC', 'Last2, First2 M')

;

insert into Provider (FirstName, MiddleName, LastName, Role, FullName) Values

('Sam', '', 'Ramirez', 'FC', 'Ramirez, Sam'),
('Ben', '', 'Romanowski', 'FC', 'Romanowski, Ben'),
('Ken', '', 'Huang', 'FC', 'Huang, Ken')
;

update Provider set DutyLocation = 'Durham' where Role = 'FC' and ProviderKey in (11422, 11425, 11418, 11423, 11416, 25225, 11424);
update Provider set DutyLocation = 'Menlo Park' where Role = 'FC' and ProviderKey in (11421, 11420, 28582, 28583);
update Provider set DutyLocation = 'Honolulu' where Role = 'FC' and ProviderKey in (11426, 11415);
update Provider set DutyLocation = 'Martinez' where Role = 'FC' and ProviderKey in (11431);
update Provider set DutyLocation = 'Ann Arbor' where Role = 'FC' and ProviderKey in (14076);