Welsh Corgi (2/16/2012)

---

I tried it and it did not...

bet you left the "AS...

Eugene Elutin (2/16/2012)

---

I like it and have another one:

Exit from unexitable situation is usually located at the same...

as calvo stated, you'll need to include the complete case statement in your group by.

One of the reasons to use a char data type over a varchar is to avoid performance problems if the column gets updated some time after the row has been...

Eloquently stated...

Hmmmm... I always thought you needed enterprise edition to save them.

paul.knibbs (2/2/2012)

---

As a set in my ways C programmer, I find it irritating enough that SQL overloads the = operator to mean both assignment and a test of equality (I...

I'd run a profiler trace. Look for any batch requests coming from your computer. You probably have some tool running that is causing this.

set up a view that includes the global @@servername as one of the columns in the select. Reference this view from your SSIS task.

Should not be necessary in company with competent leadership.

In my experience, companies where the managers and officers are clueless about morale (or anything else for that matter) wouldn't believe anything...

Personally, I am growing more and more fond of Celko's approach with each passing day.

jcrawf02 (1/26/2012)

---

Lynn Pettis (1/26/2012)

---

I had a 1990 Ford Festiva. It was a trooper, went 30,000 miles without an oil change once. First mechanical work (right front toe arm) at...

Eric M Russell (1/26/2012)

---

Coincidentally, while shaving and getting suited up this morning, I started thinking about the idea that we should not consider the time we put in at work...

welcome to the party. 🙂