From: a@a.com   
      
   > But creating a view is little different to creating a stored procedure.   
   > Either way, you have created something on the server - ten lashes!   
      
   he he good point! :-)   
      
   > Which would they prefer?   
   >   
   > a) CR brings the server to its knees every time someone runs a report,   
   > so basic reports can only be run out of hours or against a separate,   
   > not-quite-up-to-date data source; or   
   >   
   > b) you build some views and stored procs in a separate schema to enable   
   > reporting to run efficiently?   
      
   I think I'll go the view way.   
      
   Thanks for your help!   
      
   kristoff plasun   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)