Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Dynamic changing sort column and direction

Author  Topic  Wouter Starting Member 8 Posts Posted - 2000-12-08 : 03:58:15 Hi, I have a SP in which I like to change the 'ORDER BY' part on the fly. So I like to pass a parameter with a value like 'Col1 DESC' and use this parameter in the order by section. Is that possible and how would I do this? Thanks Professional Developer @ Flyersoft Inc. Visit our forums.