39? Has it been that many already.

Without the STUFF there I had to look up STUFF again to remind myself how it worked and how it could have been applied to the code had it been...

Neither can I.

Thanks for the question.

Thanks for the script.

Thanks for the script.

Thanks for the script.

dwain.c (1/15/2013)

---

You might want to look into using the CROSS APPLY VALUES approach to UNPIVOT (see the first article in my signature links). I find it much more readable...

Thanks for the script.

Thanks for the script.

Thanks for the script.

Thanks for the script.

Oliver Wootton (12/17/2012)

---

Using hand crafted scripts is all well and good, however you should enclose the database name in [ ] to avoid databases containing a space in their names;...

Thanks for the script.

Thanks Harsha for the script.