converting from varbinary(max) to xml

[amer shammout]

I am working on sql server 2008 I have a table with a varbinary(max) filed I want to store a row of this table in ather table in xml filde so when I write a query and set in the end of query (for xml auto) an error was occered what can i do

[Lost User]

What did the error message say?

I are troll :)

[amer shammout]

FOR XML AUTO could not find the table owning the following column 'Logo' to create a URL address for it. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the 'dbobject/TABLE[@PK1="V1"]/@COLUMN' syntax.

[Lost User]

According to the syntax mentioned in this[^] blogpost, I'd assume that your statement would work if you add the BINARY BASE64 option like this;

FOR XML AUTO, BINARY BASE64

I are troll :)

[amer shammout]

thanks