Yes, there are ways to do it, but they are a lot of work and they perform very poorly. In general if you need to dynamically specify the columns...

Lynn Pettis (5/7/2009)

---

The really sad part, he is probably working on an off-shore project for some sap company here in the US that thinks they have someone with a Masters...

Looks OK to me.

Also, this is pretty straight-forward, I doubt that there is anyway to speed this up.

As for how he keeps his job, there are two obvious possibilities: 1) Civil Service, and 2) Nepotism. These two work pretty much the same, to one degree or...

Actually, I think that his reply to me makes the whole graduate studies thing pretty clear: its complete hooey. Numerical Analysis is not like Psych 101. You can't...

Lynn Pettis (5/6/2009)

---

I refuse to post a link, but I really want to know what our favorite PhD candadate learned while in school for his current degrees.

I'm also curious how...

What's your hardware architecture? Do you have a SAN?

Well SQL Injection is the biggie. Wish I had a buck every time one of my customers found out that their vendor was exposing them to SQL Injection attacks.

Dude. This code post is really big and is causing the page to hang for me (and others, I presume)

Could you edit your post and move the code into...

SELECT *

INTO NewTable

From yourTable

Will create a new table with all of the column definitions taken from the '*'. On the other hand it will not work if...

That's not a...

FYI, the larger the string to be made, and the more strings to be concated, the better FOR XML does wrt to all other workable solutions in SQL 2005. ...

Static SQL stored procedures are compiled and bound to the objects in the same database, unless another DB is explicitly named in an object reference. You cannot parametize a...

Saving it as XML should make it a *.SQLPLAN. Then you will have to zip that.

Can you attach the .SQLPLAN in a zip?