Staff Name & Staff ID

Select description, staff_id from dbo.Staff where staff_status_KEY= 1

Staff Name Only

select description from dbo.Staff where staff_status_KEY =1

Note: remove 'where staff_status_KEY =1' when firm wants active and inactive staff to sync
