... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 17,964 of 19,505

Andrew Morton to Hugo Kornelis

Re: Common Table Expression slow

21 Oct 10 09:18:02

   From: akm@in-press.co.uk.invalid   
      
   Hugo Kornelis wrote:   
   > On Tue, 19 Oct 2010 16:25:25 -0700, tshad wrote:   
   >   
   >>   
   >> "Andrew Morton" wrote   
   >>> tshad wrote:   
   >>>> WHERE (@Status = 'ALL') OR ((@Status <> 'ALL') AND (dStart =   
   >>>> (Select ...   
   >>>   
   >>> Unless my brain deceives me at this early hour,   
   >>> A OR (NOT A AND B) is the same as A OR B.   
      
   Umm... would I be wrong if @Status was NULL?   
      
   --   
   Andrew   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]