Wednesday, March 21, 2012

Problems with ORDER BY clause

Need to pass column to ORDER BY as parameter in sp (possible 8 columns out of total 30). Is there a way to do it avoiding dynamic SQL use(will be used frequently)?Heh, it seems that after posting question it's easier to find solution :).

If anyone is interrested in answer, there is article on SQLServer Magazine treating this problem:
http://www.winnetmag.com/Article/ArticleID/16495/16495.html

No comments:

Post a Comment