My all time favorite... "I have 3 tables... yada-yada-yada... how do I join them?" I have to admit, I don't even bother answering those anymore. Not a...

Mmmmmm... tasty... expensive, but tasty.

So! Anybody wanna talk about all the companies that use spreadsheets like databases? I'll start... I hate them all. 😛

Bob Hovious (1/21/2009)

---

I haven't scrolled through all 60 or so messages to see if this was mentioned so it may be redundant.

I sometimes get one-shot requests for a simple CSV...

J (1/22/2009)

---

The OP has ignored repeated requests as to the WHY of it.

On top of that he has been warned repeatedly that is a bad idea.

If all he wants is...

ric (1/20/2009)

---

I don't want to concatenate 2 different fields I want to concatenate all of a particular Field.

So if Column is Total and Rows are days of week. Mon=1,Tue=2,Wed=3,Thur=4,Fri=5. In...

PG (1/22/2009)

---

GilaMonster, GSquared, Jeff Moden,

You guys are killing me here 😛 !!! I mean, "Pork chop thru the nose", now that's funny :w00t:.

To quickly end the suspense, I am a...

How are my fellow employees going to make better decisions if they know what...

Are you saying it took overnight to...

GSquared (1/22/2009)

---

Because violations of first normal form are so much fun! And the entertainment value from trying to work out delete and update code for string lists is enough...

PG... although we're having a bit of fun at the expense of your dilema, it would be good to know why (the actual business reason) the table is denormalized the...

No, sorry... I can't even remember who the "argument" was with...

Touch a minimal set of data, a...

Yep... that's the one. And, after reading that bad boy, I have to say that the feeling is mutual, Vince. 🙂

Also, be real careful with ISDATE... the following will return a "1" as will many other things...

SELECT ISDATE('2008')

Lynn is...