Thank you, ColdCoffee, for using a simpler example. That makes the concept of CROSS JOIN with a WHERE clause easier to understand.

To me, that's a more elegant solution.

I'm sure that, as some point on these forums, I've asked a question and indicated that I needed an answer in a hurry. I think that, when I read...

"Wet paint". I've never heard that phrase to describe code that is still in process, but not yet ready to be used. I like it!

Rich-403221 (4/8/2010)

---

OK. I can't resist joining this one.

When I was in high school I worked in a shoe store (no Al Bundy jokes, please). We would send the newbies to...

john.arnott (4/6/2010)

---

Rod at work (4/5/2010)

---

A friend of mine thinks that if you cross the International Date Line, say going from west to east, that you can actually travel back in...

A friend of mine thinks that if you cross the International Date Line, say going from west to east, that you can actually travel back in time. I kid...

Man, you had me going there, Steve! I am so gullible.

Gail,

I appreciate this feedback, and especially from you. This is the sort of thing that I've got to hear, so that I can see how better to architect solutions...

Jeffrey Williams-493691 (3/3/2010)

---

Well, I wouldn't say it was normal either - but I have seen it quite often. Mostly where the company wants to be able to deliver their...

Lowell (3/3/2010)

---

definitely not normal. foreign key relationships are a best practice.

I've encountered this before, and it seems the companies think that their schema would reveal their business processes ro something,...

Excellent information, Lynn, thank you! Well then I can see that there won't be a lot of activity on our Master database, as we don't do most of those...

Hmmm. That is not a bad idea. I'm not sure how much space we'll be able to get, though.

I have no idea how often, nor by how...

The Master database is set to Full for the...