Shifting gears a bit but on a similar subject... the PIVOT operator in MS Access is totally awesome.  I do NOT understand why MS made such a crippled...

Shifting gears a bit but on a similar subject... the PIVOT operator in MS Access is totally awesome.  I do NOT understand why MS made such a crippled version in...

As almost a sidebar, try a couple of things on your original query (posted below just so you don't have to look back.... they've worked for me in the past.

insert...

My thanks to Jeff, Voldemar and Scott.

@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while I missed the...

Sorry, I have explained that badly. It definitely isn't a bug in SQL, but it can cause a bug in my software (if I change from ISNULL to COALESCE...

Exactly... and it's easy to use and it doesn't have any...

I admit, I don't expect IIF to go away (ever), as bad an idea as it was to corrupt T-SQL with it.  I'm just hoping they don't bring over...

COALESCE has a nasty quirk, as well.  You know what it is... it uses whatever the highest precedence datatype there is in the operands.  ISNULL doesn't have that...

by the way, since we already have touched the subject,

is it a good idea at all to execute anything like this on a remote server as EXEC  (...)  AT...

It would have been much more neighborly of you if you had read the article at the link I directed you to and provided the data in a "readily consumable"...

Curious... which solution?

I agree entirely, but this blog was intended to focus purely on the relative performance of XML Lists, because the comments about their poor performance when used as parameters...

As a guy who constantly advocates for ANSI/ISO standards, I would like to point out that the CONCAT is not SQL but local dialect. The correct syntax is in...

I'm thinking that you've changed the purpose of the code.  The first query in the code uses the 3 part naming convention and seems to be meant to look at...

I guess I'm a little confused... You already know the remote server name or you wouldn't be able to query its' msdb database.  Why not just substitute a literal for...