Thank You Michael,

The saddest part of the answer is I submitted the question 5 years ago!!!  LOL!!!!

Shows how long I haven't used it...

Thanks Again

So I figured out a work around using

and Data.value('(/Data/Type)[1]', 'nvarchar(100)') is not null

but if anyone else knows another option, always good to know...

Yes, Thank You just found i!!

It's the third , but who's counting? Except you ... but thanks for the feedback

Thanks for getting back,

I have this SP that runs on a reporting services application where the DB used to be Backup and restore.

Although it has a bunch of select statements...

Thanks... I guess my issue is something else.... 🙂

Hi Joe,

I found the downloaded excel file was in "General" format.

I needed to submit this file for processing thru an SFTP site, and wouldn't accept it as "General" and needed...

Found it! !  Googled my own question...  lol

If anyone is interested, when downloading to CSV , probably excel also, it uses the Textbox name....

I learned something new today !!

Thanks... ll' mess around in my sandbox 🙂

Thanks for getting back Phil.

So a select within a select is covered as long as it's before...

I get the drawbacks but it's for a table I build for a report...

No, the databases are on each server

I write the table to a DB I store the Stored procs. Just read from the replicated DB

I'm definity  getting waits  I'll start reading about log shipping

Hi Andy,

Thanks for getting back. Sorry, I am horrible at explaining the situation !

Let me try again.  I do solely reporting, but I do have this job that creates a...

Thank you...

Let me do a bit of reading, see if I can come up with something, maybe export to python or something....

I'm sorry...

I was way off it's an nvarchar(MAX) field. I put a sample below of what the field contains.

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"><svg xmlns="http://www.w3.org/2000/svg" version="1.1"...