Kenneth.Fisher (1/3/2013)

---

I looked at Quotename when I was writing this but honestly I'm still not sure exactly what it does. I tried it...

Michael R. OBrien Jr (1/2/2013)

---

I guess I have never been a fan of triple quoting, I usually use CHAR(39) I find it is a lot easier to read for others:

SELECT...

thanks for the book reference

Good article. Interesting that my create table/insert while loop (to 10,000 rows) executed in 4 seconds and the set based solution executed in 17 seconds.