Thanks Jeff for this nice and very well explained article.

Alexey Voronin (10/15/2010)

---

I was making my own experiments with this on a very busy server in fact. Neither XML nor delimited string of data produce optimal results. The best was...

I tried to check time taken by the suggested SQL on my machine.

I have a table containing 10404147 rows. Searched on a varchar column, which is not a part of...

Nice article and I think better approach.

I have solved the same problem but in different way. Please have a look.

http://www.sqlservercentral.com/articles/Comma+seperated/67417/

Thanks,

Nizam

Nils Gustav Stråbø (5/20/2010)

---

mohd.nizamuddin (5/20/2010)

---

Very well written, a nice article.

Can you please put some light on the excution plan of this SP, while writing dynamic SQL.

As per knowledged, the...

Is it Vladmir... 😎

Thanks for...

Very well written, a nice article.

Can you please put some light on the excution plan of this SP, while writing dynamic SQL.

As per knowledged, the execution plan won't be...

Oleg Netchaev (4/13/2010)

---

Thank you Paul for excellent article, I thoroughly enjoyed reading it. Looking forward to read Part II next week. I usually start using new language features pretty soon...

Paul White NZ (4/12/2010)

---

mohd.nizamuddin (4/12/2010)

---

Nice Article Paul. It is very well expalined with example.

I have a doubt, since the UDTF would get executed as many times as the row count...

Nice Article Paul. It is very well expalined with example.

I have a doubt, since the UDTF would get executed as many times as the row count of primary resultset (Student's...

Very nice and informative article...

This is what we do in real life as well (Use of SELECT *). Even though we hear from everybody that to avoid SELECT * always.

So,...

Thank you Paul, for your detailed explanation. Really this help me a lot to know something extra about the SQL.

Jeff Moden (1/8/2010)

---

Actually, how it works or not behind the scenes is neither the problem nor the question here. You've simply told it take take a "Distinct" on the...

Thanks a lot. I...

Excellent article.

BTW I have another version of CTE, which splits delimited string without tally table. I think it works efficiently, also. Please have a look...:-)

DECLARE

@list VARCHAR(MAX),

...