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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?