I know why, replace error on my part as...

ScottPletcher (9/27/2016)

---

So you want to go from DBA-level SQL to developer-level SQL:

Destroy half your...

Also, a slightly more robust way to get the column names and and data types:

declare @collist nvarchar(max),

@schema nvarchar(128),

...

Only issue I see with the global temporary table would be if the procedure is called at the same time by multiple sessions.

The only way you will be able to do this is to dynamically create a table data type and then use that declare your table variable.

The end of your editorial reminded me of the PSA's on the Armed Forces Network talking about the obnoxious drinkers (male or female).

Don't be that guy!

The way it is shaping up right now, it is possible that, not only will I have the lowest winning score for the week, but that I may have lost...

Should have played Tannehill, you would have beat me.

My players weren't that much better.

Sector7G (9/23/2016)

---

If you are getting this error, try to modify the proc in a different version of Management Studio.

I have been dealing with this problem all afternoon. ...

Task Manager? No.

Ken McKelvey (9/23/2016)

---

It should be relatively cheap to upgrade the amount of memory in the servers to 32GBytes.

(I think that is the maximum for the standard version of WS2008R2.)

It is...

Smendle (9/23/2016)

---

Sergiy (9/22/2016)

---

Smendle (9/22/2016)

---

i could be confusing this with a .NET programming environment but doesn't that...

The OP that posted it????

Luis Cazares (9/22/2016)

---

drew.allen (9/22/2016)

---

Sue_H (9/22/2016)

---

My thoughts as well. The follow up to that specific question could be interesting if someone doesn't know what would be different between...

It is a test system, it may be slow but it is acceptable for what you are doing? I'd be more concerned about it if it was a production...