Last post Dec 07, 2015 02:35 AM by Zhi Lv - MSFT
Dec 04, 2015 06:59 PM|peterthegreat|LINK
My procedure when run throws the following line: Invalid column name 'ProductPrice DESC'.SET @sql = ' SELECT * FROM
(SELECT * ,
ROW_NUMBER() OVER(ORDER BY [' + @sortExpression + ']) as RowNum
FROM Products WHERE COSTADJUSTOR IS NOT NULL )AS EmpInfo '
UpdateProblem solved. It was a simple case of square brackets interfering in some manner ?
Dec 07, 2015 02:35 AM|Zhi Lv - MSFT|LINK
Glad to see you solve this problem by yourself, it will help others to resolve similar problem.
Have a nice day.