NVARCHAR(MAX) works. Thank you!

Ninja's_RGR'us (5/11/2011)

---

Actually I would put the name in brakets as well. In my system half the columns use spaces and other funny characters. This is most likely why...

ISNULL solved my problem.

SET @sql = 'SELECT ''' + STUFF((

...

Sean Lange (5/11/2011)

---

Please don't create new posts to continue a topic. it just fragments discussions and makes it harder for other to learn from the solution. As you stated please...

ohhh, you are right....

Ian Scarlett (5/11/2011)

---

Is the dynamic part so long that it wouldn't fit in 4000 characters?

Couldn't you put the first part in one variable, the dynamic part...

Ninja's_RGR'us (5/11/2011)

---

Keeo in mind that the select and print statement won't go over 8096?? characters. So if the query is longer you can't copy / paste it. But...

Did...

Ian Scarlett (5/11/2011)

---

In SQL2000 you could get over any limit for the size of the variable containing your SQL by declaring and executing the SQL from multiple concatenated variables. These...

Yes, normally what we supposed to do is, get the data, match it with column names to xml tags and send as a...

Because I'm writing an non-intelligent process. I need the data attached with it's column...

I did that 10 seconds before your post 🙂

For the time being, no I can't.

I replied to this at:

http://www.sqlservercentral.com/Forums/Topic1106818-391-1.aspx

Thank you.

More specifically,

DECLARE @sql NVARCHAR(MAX);

SET @sql = 'SELECT ''' + STUFF((

...

It's interesting, when I tried it, I didn't get any errors but also nothing returned from the query.

When I run the same query with NVARCHAR(MAX) for a...