View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:43 PM
brazil.mg.marcus.vinicius.lima
 
Posts: n/a
Default Reusing a generated column to avoid over processing

Hi,

I'm constructing a query that will performs a lot o datetime
calculumns to generate columns.
All that operations are dependent of a base calculum that is performed
on the query and its result is stored in a columna returned.

I wanna find a way of reusing this generated column, to avoid
reprocessing that calculumn to perform the other operations, cause
that query will be used in a critical application, and all saving is
few.

Thanks a lot.

Reply With Quote