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 Ordering

Author  Topic 

darinh
Yak Posting Veteran

58 Posts

Posted - 2001-04-17 : 12:47:25
Hi,

I am dynamically ordering a recordset using the CASE techniques as described in
[url]http://www.sqlteam.com/item.asp?ItemID=2209[/url].

The problem I have is dynamically choosing whether to order ASC or DESC. It seems like it should be easy, but I can't seem to do it without duplicating my query and putting another CASE around the whole thing

Thanks.
   

- Advertisement -