SQL Server Merge Statement with ROW_NUMBER Function: Troubleshooting and Best Practices

SQL Query Update: Using CTE to Correctly Calculate OverStaffed Values