Dynamic ordering ambiguous column issue

There two ORDER BY statements in your query. Do you want to replace both of them by @SortColunm? And also I did not see you use RowNum in your query. Not sure why you need ROW_NUMBER() .......

---

A Fan of SSIS, SSRS and SSAS