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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment