6e0f3657   
   From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Tue, 3 Nov 2009 16:22:22 -0800 (PST), bill wrote:   
      
   >I don't like persisting derved data, but it makes sense in this case,   
   >because it's a write-once read-many situation.  Given that it is going   
   >to be persisted, the choice is between a persisted computed column and   
   >a trigger, and I like the computed column much better.   
      
   Hi Bill,   
      
   Have you considered using a materialized view, as a third alternative?   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)