Stored Procedure Order By Variable

[OberCanober]

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...

CREATE     PROCEDURE spVerifyComplete

(
@Order1 as column,
@Order2  as column
)

As
 SELECT
*
 FROM RSR
 WHERE (RSRCompleted = "NO"
ORDER BY @Order1, @Order2

GO

But it don't work.

Can someone tell me what I did wrong?

Thanks,

-Ober