title: Order by clause is invalid in common table
body: <p>Throwing and error "The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified".
   When I user top 100 percent, throwing different error like one of the coloumn used many times</p>