From: miroslavsi@gmail.com   
      
   Hello,   
      
   I need to provide sorting ability across multiple column.   
      
   Data which would be sorted are retrieved with stored procedure.   
      
   I have two solutions:   
      
   1. if statement   
   depending of sort type I must create diferent select statement   
      
   in case many columns there would be so many variations (also, there must be   
   considered sort direction ASC or DESC what increase variations double)   
      
   2. dynamic sql   
      
   Is there any additional way, which one is better?   
      
   Please advice,   
      
   Best regards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)