Dynamic ordering ambiguous column issue

In your query, DISTINCT ROW_NUMBER() OVER(ORDER BY Emp_ID) AS RowNum has an issue since there are three tables which have Emp_ID column. You have to tell which table's Emp_ID is used in ORDER BY.

---

A Fan of SSIS, SSRS and SSAS