SQL Server Table Sync - Modifications to Records (leavers, news hires and movers).
Budget: $30 – $250 USD
The SQL PROC will need to compare two database tables ( I will provide the table structure and sample data)
New additions to the table are new staff that have joined the organisation and should be emailed to the Service Desk within the PROC.
Leavers are records which do not exisit in the table and should be emailed to the Service Desk within the PROC.
Changes in staff departments or roles should be emailed to the Service Desk within the PROC.
Teh PROC will need to maintain an audit trail of record changes
New additions to the table are new staff that have joined the organisation and should be emailed to the Service Desk within the PROC.
Leavers are records which do not exisit in the table and should be emailed to the Service Desk within the PROC.
Changes in staff departments or roles should be emailed to the Service Desk within the PROC.
Teh PROC will need to maintain an audit trail of record changes