ROW_NUMBER() function in SQL 2005

Question

Can this function accept parameter in the order clause?

WITH LogEntries AS (
SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)
AS Row, Date, Description
FROM LOG)

Instead of using "ORDER BY Date DESC", I would like to use "ORDER BY @SORTCOLUMN". But I could not get this to work properly.

 

Thanks,

 

Answer 1

You could use dynamic sql (execute a string using EXEC or sp_executesql).

Answer 2

Thanks