That's quite a request you've made there...

Oddly enough Celko, I agree with you.

It is maddening that the formatting is done within the SQL and if I was here when the system was designed I would...

Thanks for the prompt responses.

I'm going with Mark-101232's answer, as it's easier to implement in the real code, but I appreciate the two solutions.

2008R2 SP1 - runs without error.

2008 SP2 - 'severe error'

2005 - 'severe error'

WayneS (11/1/2011)

---

Stefan, Kiera, Chad

Thanks for your replies. The fact that he co-authored a book with Bob Beauchemin does help things a little bit. Still wondering just how much use these...

I'd never heard of SQL_VARIANT, thanks for the question.

As a starting point, the following code produces a csv string of the IDs from the selected Adventureworks table:

use AdventureWorks

select stuff((select ',' + cast(ContactID as varchar) from person.contact FOR XML...

And if you should (for some strange reason) have 2 iPad 2s, halloween is upon us:

http://gizmodo.com/5854649/best-costume-use-two-ipads-to-create-an-awesome-gaping-hole-in-your-gut

GilaMonster (10/26/2011)

---

BrainDonor (10/26/2011)

---

No no no no no - if it doesn't make the bookshelf bend then it isn't worth buying. I haven't yet moved to ebooks (unless it's a free...

I thought we'd hijacked that thread enough, so I've moved over here:

Ninja's_RGR'us (10/26/2011)

---

BrainDonor (10/26/2011)

---

Available now over there, but not over here. By the time it was shipped over I could...

Available now over there, but not over here. By the time it was shipped over I could probably get it over here now and that also requires some additional effort...

Two more weeks before Amazon in the UK have that. Not a happy bunny.

In the UK it isn't illegal to use a hands-free mobile phone system, although it isn't recommended (Highway Code - para 149). Research has shown that even hands-free is a...

This article may give you a starting point:

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

When you say 'it errors'. I assume you mean the line of code is highlighted as an error once you leave it? Or are you getting an error when executing...