Viewing 15 posts - 16,096 through 16,110 (of 18,926 total)
Actually this is much simpler :
select productid
from dbo.product_cities
where city in ('boston', 'chicago', 'denver')
GROUP by productid
having count(*) = 3 --number of cities in the in clause.
June 29, 2005 at 5:44 am
Select name, A, B, C, D, (A + B + C + D) / 4.0 as Average from dbo.YourTable
June 28, 2005 at 10:28 pm
Would be nice if we could lock out the admins sometimes
.
June 28, 2005 at 10:26 pm
I can't test from here... reply to this message so I won't forget to answer this one tomorrow.
June 28, 2005 at 8:40 pm
It's the first time I see you hold something in. Don't worry for me, I've been burned before.
.
June 28, 2005 at 6:14 pm
There was a leak a few months/years back. The code was a 600+ mb ZIPPED file. That accounted for only 2% of the source code (win 2K).
It may...
June 28, 2005 at 6:10 pm
Not a chance... unless someone here thinks otherwise
.
June 28, 2005 at 3:09 pm
Still, with a few hundred billions lines of codes, running a few thousands of possible install combinaisons or software/versions, you're gonna miss a bug. There's no way they can come...
June 28, 2005 at 3:07 pm
Just a quick question... In what situation would you want to know that information (exists but doesn't wanna say, or we kow it doesn't exists). Why not just go,...
June 28, 2005 at 2:58 pm
I would assume that OrderID is part of the primary and therefore included in the index. So a simple index on the OrderDate would be enough.
June 28, 2005 at 2:54 pm
Can you imagine how much testing is required just to have that little bugs??? I wouldn't wanna have to manage all that work...
June 28, 2005 at 2:49 pm
Ya but it kills the performance of the index seeks... maybe it's time to test SP4 in developement and see if it breaks anything else before applying it.
June 28, 2005 at 2:31 pm
Viewing 15 posts - 16,096 through 16,110 (of 18,926 total)