Despite appearing to get the solution they desired via Sean's post, the OP never got around to actually specifying the exact conditions he was working with, and everything had to...

I'll assume your query produces a single record with the XML data type, and as the UNION ALL expects data types to match, and that my idea assumed a different...

Without knowing the details of the method you're using to generate said XML, it's hard to make a good choice about how best to go about it. ...

Can you be more specific about what you are trying to do? The words you used give me nothing in the way of a clue as to exactly...

Failing any of the previous suggestions, I'd start looking at available resources... Does the server have enough RAM to run all the existing instances? Is...

Not sure this post will make your day any easier, but here goes...

You might want to try and build a TEST workstation fresh from the image and install in the...

Boy, a typo sure can bite you (Ouch! :w00t: ), and once committed, keep biting... Poor Jeff... his bite took out his CMOS battery...

Anyway, you appear to be...

It's always a positive to find out someone cares about your frustration. I only have so much time in a given day, and getting half a dozen emails...

I think you've forgotten the purpose of tracking a discussion... to hear relevant points when they are made. I see no reason to have to go spend hours...

Fly in my cereal ? Nope... just a statement of fact. I got a whole bunch of e-mails indicating updates to this topic, and...

I hate to have to say it, but folks - this topic started almost 3 YEARS AGO !!! It's already had pretty much everything there's likely to...

Re-opening a 3 year old post isn't really the right way to go about this, but the bottom line is that I suspected that any reply from the original poster...

The problem usually shows up when you are trying to export to a text file, and the presence of any one NULL value throws the entire output record into NULL...

I'm at the point of making an assumption about what the poster meant by their most recent post. Given the technique of concatenating a series of ISNULL functions...

The number of fields that can be included in the query's use of ISNULL and NULLIF is not limited to two. You can just keep concatenating an ISNULL function,...