Calvin Lawson (5/7/2008)

---

OMG, everybody out of the pool, quick! Read this article, now! Do not write a single piece of SQL code until you've finished it, and understand...

Heh... it kept me up all bloody night! But "When in...

Shamshad Ali (5/7/2008)

---

Hello,

My quewtion is related to replacing loop, I am very interested on this. coz i really want to improve performance and I can't find a way to...

Heh... remember, you asked what could be done to make this more readable...

Here's one of your inserts including the indentation I found when I copied it... quick, you're...

Keith DuAime (5/7/2008)

---

ok, I am getting the result set I finally need but it's still pretty messy, I abbreviated all the data needed but this code will run alone. Any...

You folks are absolutely the Best! I'm humbled by your awesome compliments and the testing that alot of you have taken the time to do and post.

I've got a...

You do realize that code will remove all single rows, correct?

Michael Meierruth (5/7/2008)

---

Given that Jeff is in luv with cursors, we all really need...

shamshudheen (5/7/2008)

---

Jeff,

how i use COALESEC function for the following code

SET @strValList2 = ''

SELECT @strValList2 = @strValList2 +

CASE

WHEN vColName IS NOT NULL THEN '[' + vColName + ']'

WHEN vColName IS NULL...

Let's talk about just the ones for Category "A"... which one do you want to keep? The one with the lowest value EmpID or the highest?

Ah... understood.

Dunno why, but ever since I had a boss that wanted to pay me with "virtual money", I've been put off by the word "virtual". 😛 Haven't gotten...

I don't know about Sergiy, but the only big advantage I've found is that I don't have to convince reluctant DBA's into having two helper tables. I haven't tested...

The concatenation method show in the article at the following URL might help... I certainly haven't tried it on 100,000...

dfalso (5/6/2008)

---

Jeff Moden (5/6/2008)

---

Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job in...

dfalso (5/6/2008)

---

Jeff Moden (5/6/2008)

---

Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job in...