Hello,
I am creating a phone list and the list is refreshed daily using a scheduled job. What happens is the daily data gets populated into a staging table, then updates the active table.
The staging table (DailyUserList) contains the complete list of users who should be on the phone list.
The active table (Users), retains all current and historic user data.
What I would like to do is create a query that will set a user record and Activestatus to 0 if they are no longer on the daily list?