Yes.

It depends on whether it will fit in available memory or not. Same for temp tables.

Yes, negative numbers appear in the "usual" order. In this case, that's even-odd, even-odd, pairs, just like the OP asked for. -10, -9, that's an even-odd pair. ...

My home computer's mainly a gaming machine, so I go as high end as I can. Don't like to use anything less than a 22-inch monitor (that's about 56...

GilaMonster (3/26/2009)

---

I wouldn't have bothered in that case.

But then, I built my desktop myself, so for the...

Just ran some tests. They have about the same execution time. Tried both with integers from -50,000 to +50,000, including 0. Both worked for the whole range.

Why...

Have you tried using BCP for this kind of thing? Might be easier.

Divide the time by 10,000, to get the hour. Compare that to datepart(hour, getdate()), and you can get whether it's in whatever range you're looking for.

Will that do what...

You could put the level range and level step in the join table.

Thus, if the recipe goes from level 10 to level 25, but only has 10, 15, 20, 25,...

What's the 43000 mean? What does that measure?

GilaMonster (3/26/2009)

---

AAaaahhhhh!!!!!!!

Three days of major internet connectivity issues and every tech I speak to wants me to restart the machine and reset the modem.

Then, tonight, the crowning glory.

The error is...

That leaves are you running it on all 25-million rows regularly?

Also, what's the execution plan look like?

Cool.

Glad I could help. You're welcome.

Another question. The written spec at the top of your question says 20 seconds, but the query at the bottom has 120 seconds. Which is it?

The execution plan I end up with on this, from the test data, is pretty efficient for what it has to do.

My first question is, do you actually query all...