One more thing, ccundy, although you probably already know this ...

You shouldn't code DISTINCT in your subquery when it is being accessed with a set operator like IN, EXISTS, ANY,...

GMan, I have two thoughts to share with you:

1. The order of clauses in your SELECT ... INTO statement is incorrect. The correct order is SELECT columns INTO...

Your query:

Select Distinct Location From esi_PricesTemp Where Location In (Select GridPoint From esi_PriceHistoryLocations) Order By Location

In order for a row from esi_PricesTemp to be included in the resultset, the WHERE...

I didn't have time to read all these posts (true confessions), so at the risk of being repetitive, let me add my 0.02: in my opinion, certifications can help...

quote:

---

Since SQL 2000 databases have a limit of 1,048,516 TB, doesn’t that mean that a table cannot exceed that limit?

---

quote:

---

Anyone heard anything back from an admin (or other with the site)?

---

Nope. Maybe they'll...

You know, I wonder if the question might have been a repeat, and maybe I missed it the first time around. I haven't missed many questions (only 4, I...

quote:

---

But, unlike you, I have no complaints.... for me, it said I'd gotten it right.

---