I wish I can use this site more often because something happened and all of a sudden I am continuously swamped with work. I have tried to allocate at least...

Steve Jones - Editor (2/25/2010)

---

There is a lot of money to be made selling information about people. Years ago I worked in a startup and we would regularly get lists...

Steve, this has actually made me thinking of what companies do with that data. I buy clothes at one clothing shop on account and tommorrow 10 other companies have my...

Jeff, I forgot some points in my previous post to you. To hardcode a query is never good and there you have me. It looks like I am getting floored...

CirquedeSQLeil (2/23/2010)

---

Manie Verster (2/23/2010)

---

One point in all this that you are missing is that when a person is in an interview, no matter how tough you are, you are nervous...

Jeff Moden (2/23/2010)

---

No problem, Manny... I'm on your's, as well but I did install some handrails so you can enjoy the...

reidres (2/23/2010)

---

Manie Verster (2/23/2010)

---

Jeff Moden (2/22/2010)

---

Manie Verster (2/22/2010)

---

I checked out Grant Fritchey's[/url] article and was, like Jeff, not very pleased to see some while loops but one query attracted my...

Jeff I am on your case today. I took my temp table query and did a duration in ms and I got 3 ms. Guess what I got when I...

hehehehehehehehehe:w00t::w00t::w00t::w00t:

Jeff Moden (2/22/2010)

---

Steve Jones - Editor (2/22/2010)

---

No argument about the best programmer, and I'm sure I'd miss out on some jobs if this is the only criteria. In an interview,...

Martin, do measure yourself against Jeff and the likes. Someone must start somewhere. Just do your best.

Fortunately...

Steve Jones - Editor (2/22/2010)

---

LOL, in an interview, I'd think the CTE, or a short WHILE loop would make sense, having the person talk through what they're doing. This isn't...

Jeff Moden (2/22/2010)

---

There shouldn't be a Temp table...

Jeff Moden (2/22/2010)

---

Manie Verster (2/22/2010)

---

I checked out Grant Fritchey's[/url] article and was, like Jeff, not very pleased to see some while loops but one query attracted my attention and I...