View Single Post
  #3 (permalink)  
Old September 22nd, 2004, 01:03 PM
tbaquero tbaquero is offline
Registered User
Join Date: Sep 2004
Location: , , Panama.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts

I don't think i can avoid one of those because i need it to be distinct so i don't get repeated records in the asp recordset i'm showing, and because my stored procedure is so dynamic i can't avoid using the case in the orderby clause either. In fact i'm using the case in the orderby clause statement because in the asp page where i'm executing the stored procedure i have links on the column heading so the person can sort the records using that field.

Still waiting for some help...

Panama Canal Authority
Reply With Quote