terry.home (11/18/2013)

---

Would it be possible to amend this to also work on 2008 R2?

Also, seem to get an error when it reaches an offline database (so could be modified to...

stephen.long.1 (9/17/2014)

---

It's interesting that the article doesn't have a counterpart in versions of BOL later than SQL Server 2008 R2. The "Other Versions" drop-down only shows "SQL Server 2008" and...

I got it wrong because he talked about 4-part naming and then only used a 2-part name.

It seems if he says he's "working in" the database, that mean he's connected...

Hello Greg,

Another good article. I have enjoyed this stairway series.

In this article I noticed a few inconsistencies that may be from changing your examples?

Several places you use "DELETE" where maybe...

Maybe he means something like this?

Select name + ' | ' + CONVERT(varchar(3), [count]) As Result From some_table

Hard to tell. The question doesn't make any sense.

Maybe you need to learn...

If you run with @debug = 1 in SSMS, you can look in the...

For both versions I got this:

Msg 102, Level 15, State 1, Line 26

Incorrect syntax near 'GO'.

"None of the above" was not an option so I knew something was off...

Did anyone...

duplicate post.

I have a suggestion: You say:

I think you might have made the description more clear...

Thomas Abraham (3/18/2014)

---

timwell (3/18/2014)

---

When I ran the script I got the following:

Msg 1701, Level 16, State 1, Line 1

Creating or altering table '#cTab' failed because the minimum row size would...

When I ran the script I got the following:

Msg 1701, Level 16, State 1, Line 1

Creating or altering table '#cTab' failed because the minimum row size would be 16011, including...

I have a question.

I got crossed up because the documentation says that sp_serveroption and openquery are for connecting to remote or linked servers. I was thinking the delete was happening...

ronmoses (3/11/2014)

---

Stewart "Arturius" Campbell (3/11/2014)

---

ronmoses (3/11/2014)

---

The answers appear to suggest that the following is true:

"The columns in new_table are created in the order specified by the select list."

However, http://technet.microsoft.com/en-us/library/ms188029.aspx says...

"Specifying...

bob2dis (2/23/2014)

---

I continued with my previous method until someone could give clarity on the above. Working with the message relating to converting as a string I now have a different...

Not sure if this will do what you need, but there is an example in this stairway article for replacing NULL with a string while doing a ROLLUP.

http://www.sqlservercentral.com/articles/Stairway+Series/87629/