Sure, but you can often do them faster and easier with a cursor than with a temp table and while loop. And fast and easy is great for a rarely-run...

Thanks much. I imagine most people have written some version of this with the columns they most need, but a single script collecting them all is great. I've got my...

I didn't think Manie was being mocking, certainly not intentionally. Manie, I appreciate the humility you've shown in being willing to share your own mistakes so that we can learn...

Thank you for being willing to share an embarrassing story! I bet we have all made big mistakes, but we aren't all brave enough to admit it.

It is a good...