I'm trying to pass in a parameter to a stored procedure to ORDER BY, but am
This is what I'm doing...
CREATE PROCEDURE dbo.DAVID GetSearchList
Checking the syntax gives me this error:
Error 1008: The SELECT item identitied by the ORDER BY number 1 contains a
variable as part of the expression identifying a column position. Variables
are only allowed when ordering by an expression referencing a column name.