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,947 of 19,505 |
| Andrew Morton to tshad |
| Re: Common Table Expression slow |
| 19 Oct 10 08:58:39 |
From: akm@in-press.co.uk.invalid 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. -- Andrew --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca