I'm working on a query that will be used to automatically generate XML files overnight. I'm trying out BCP to accomplish this. The only problem with this method is that the output is just one long, continuous string. Is there an easy way to add indentation to the XML data so that it looks nicer?
It seems like my only options are to use a format file with BCP, or to use a third party app such as TIDY. Are there any other options that might be better?
It seems like my only options are to use a format file with BCP, or to use a third party app such as TIDY. Are there any other options that might be better?
