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
Default

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...

TANIA P. BAQUERO
Panama Canal Authority
Student
Reply With Quote