Dynamic ordering ambiguous column issue

In your query, I did not see the table AS p. so the condition p.First_Name, p.Last_Name would fail.

---

A Fan of SSIS, SSRS and SSAS