I want to query my table with a stored procedure with a way for the user of my program to change how the data is ordered.
So I wrote my Stored procedure out like this...
But it don't work.Code:CREATE PROCEDURE spVerifyComplete
(
@Order1 as column,
@Order2 as column
)
As
SELECT
*
FROM RSR
WHERE (RSRCompleted = "NO"
ORDER BY @Order1, @Order2
GO
Can someone tell me what I did wrong?
Thanks,
-Ober
