_{Was it her birthday?}

Oh John!

Chasm

This query shows how to split a...

Purrsuasion

What about "J. Smith", "J Smith", "Smith, J" and "Smith, J."; what about "John C. Smith", "John C Smith", "J C Smith", "J. C. Smith".

The endless possibilities can make searching...

Armour-piercing bodkins.

Yes, first thing this...

Brandie Tarvin (10/1/2010)

---

GilaMonster (9/29/2010)

---

Kit G (9/29/2010)

---

Because a woman couldn't possibly be wrong and therefore whatever she came up with would work...

CirquedeSQLeil (9/30/2010)

---

Grant Fritchey (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither...

You don't need to join the CTE back to the source table, you can update it directly:

DROP TABLE #TABLE_1

CREATE TABLE #TABLE_1 (S_NO INT IDENTITY,PRODUCT_NAME VARCHAR(10),PRODUCT_ID INT, COUNT_1 INT DEFAULT 0...

It's just an opinion but "Please stop programming until you have read at least...

Lamppost.

Funniest thing I ever saw was a dog taking a leak against a lamppost with exposed live wires. It wouldn't have been funny if the dog was hurt....

Of course. He was testing you. You've learned a little respect.

Jack Corbett (9/29/2010)

---

So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does...