Wow, it posted afterall... Hopefully it lives up to my description. If not ignore the one that is less meaningful or less offensive.

Jeff Moden (12/23/2007)

---

Sorry about the banter... I just get really pissed when I see folks offer a "trick" solution that folks might perceive as being a panacea for a certain...

Well crap! I just took about an hour to enter a very detailed and intricate response to this. And of course after hittign the "post quoted reply" I got "...

Jeff Moden (12/23/2007)

---

Absinthe (12/23/2007)

---

Actually we have 2 differnt issues here:

1.

I was not saying that the code was fast, merely that it specifically satisfied the described problem of doing it...

Woohoo!! Electric pants!!

Actually we have 2 differnt issues here:

1.

I was not saying that the code was fast, merely that it specifically satisfied the described problem of doing it inline...

Faster for whom? If it is faster for SQL Server and the computer/network etc... Fine! However, if it is just faster for me to type, it is not worth the...

Red Flag time again. I...

Jeff Moden (12/21/2007)

---

The best answer for SQL Server 2000 is, in fact, the Temp Table solution. It's nasty fast, especially if you use a SELECT/INTO.

The solution that Absinthe showed...

Well I gave it a shot. But apparently the script entry screen does not handle preformatted text so well. No matter, i am sure people can come to the forum...

Not sure I follow you... please use it, I cobbled it together from about 7 different sources and then tweaked it a bit using the wonderful microsoft documentation 🙂 How...

As long as the data is unique in some way this is a simple task. I am assuming from your example that Descr is a varchar with some max length...