Comments for Paul Rohde

Comment on CSS Is A Lie. by Uriah

Uriah — Mon, 02 Jan 2012 07:40:03 +0000

Specificity can be tricky to get your head around in the beginning, no doubt. Great read, Paul!

Comment on Building a REALLY simple WCF P2P application by David Rutten

David Rutten — Sat, 03 Dec 2011 16:13:31 +0000

Fantastic article. I was about to give up on WCF when I found it and it took me just half an hour to get a chat room up and running with this. Thank you so much.

Comment on Typesetter HD by Invisible extra line height « Paul Rohde

Invisible extra line height « Paul Rohde — Mon, 07 Nov 2011 23:06:12 +0000

[...] Contact « Typesetter HD [...]

Comment on Tip: Using zoom to target images to high density displays by Jordan Ogren

Jordan Ogren — Wed, 02 Nov 2011 12:20:49 +0000

This is a great find!

Comment on SQL For XML fails with UNION or UNION ALL by Paul Rohde

Paul Rohde — Tue, 01 Nov 2011 17:30:20 +0000

Awesome, glad it all worked out.

Comment on SQL For XML fails with UNION or UNION ALL by Amal Graafstra

Amal Graafstra — Mon, 24 Oct 2011 16:20:26 +0000

Thanks for your response Paul. I went through the openquery phase with this but found I still couldn’t insert or delete records to/from a table with one or more XML column(s) on a linked remote server. I finally realized that views in SQL are updatable and set up views on both servers that use CAST to convert the xml columns to varchar(max), then I was able to set up normal queries (without using openquery) and also successfully delete records from the view rather than directly from the table. This allowed me to set up a pull job on the archive server that queried records from the live server, insert them into the archive table (converting the varchar(max) back to xml during the insert), and then finally deleting the records from the live server by deleting them from the view.

Comment on SQL For XML fails with UNION or UNION ALL by Paul Rohde

Paul Rohde — Mon, 24 Oct 2011 15:34:22 +0000

Hi Amal,

although I’m no expert on multi-server setups, I did find the following thread on the msdn forums that looks like it has a work around for your problem specific problem.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c6e0f4da-821f-4ba2-9b01-c141744076ef/

Paul

Comment on SQL For XML fails with UNION or UNION ALL by Amal Graafstra

Amal Graafstra — Sun, 23 Oct 2011 21:44:22 +0000

Any ideas when it comes to simply trying to do a union between two selects that contain columns of an XML data type? I’ve got an “active” table on the production server and an “archive” table on the archive server. I’ve linked the servers and periodically move records from the active table to the archive table using a job. Occasionally I need to run a query to find a record or records, any of which could reside in either table, and I’d like to create a single view I can query against. Here’s the goal;

select XMLField from [PRecords].dbo.[PTable]
union
select XMLField from [Archive].[PRecords].dbo.[PTable]

When I try to create the view, I get an error stating:

Xml data type is not supported in distributed queries. Remote object ‘[Archive].[PRecords].dbo.[PTable’ has xml column(s).

Any ideas, or am I just simply out of luck?

Comment on SQL For XML fails with UNION or UNION ALL by Paul Rohde

Paul Rohde — Thu, 20 Oct 2011 17:58:00 +0000

The original problem and solution was originally done on SQL 2008 R2.

Comment on SQL For XML fails with UNION or UNION ALL by Anon

Anon — Thu, 20 Oct 2011 17:48:34 +0000

Does not work on SQL 2008R2.