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...

What Data Type are the variables? If FeedType is not able to store string values or pNeedPorSessions is not configured for numeric values then you will get this error.

If they...