Very nice. Must be like voodoo, I feel ill and alien already.

I knew you were, but you were being so conscientious about just posting real Threadliness, so figured I'd take care...

:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D

15,000

:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D

One bottle of beer on the wall, one bottle of beeeeeerrrr,

take one down, pass it around, one bottle of beer on the wall

Two bottles of beer on the wall, two bottles of beeeeeerrrr,

take one down, pass it around, two bottles of beer on the wall

Right, obviously not SQL Compare. We should use Access.

CirquedeSQLeil (4/30/2010)

---

WayneS (4/30/2010)

---

CirquedeSQLeil (4/30/2010)

---

Odd question just occurred to me.

Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.

sa...

JP - and when your manager asked who said what, which one of the team told him it was inappropriate, and walked out to discuss with HR?

I think a...

Gotcha, thanks! Learn something new every day...

CirquedeSQLeil (4/29/2010)

---

Lynn Pettis (4/29/2010)

---

Plus, considering some people change thier screen names on a regular basis, attributing the code to '.' may not mean anything unless you happen to know who...

Wayne, why the isnull() and max()?

Why not just case when sp.action = 193 then 'Y' else 'N' end?

CirquedeSQLeil (4/27/2010)

---

Why find them stashed when you...

aww, golden opportunity missed.

revised edition:

"I always take the approach that I do with camping, I dig a...

Found another example [/url]of someone re-posting an article in its entirety on their blog. Not a summary, not a reference to go read it, actually a copy/paste on their blog.

They...

Chris Howarth-536003 (4/27/2010)

---

Since you asked (compatibility level 80 or lower):

WITH CTELeft

AS

(SELECT 1 AS ID UNION

SELECT 2UNION

SELECT 3UNION

SELECT...