Viewing 2 posts - 1 through 3 (of 3 total)
Figured it out.
Needed to configure the output from bcp using the -t and -r parameters. Thanks.
SELECT top 10 * from AdventureWorks.dbo.TESTING as Account FOR XML AUTO"queryout c:\test.xml...
March 19, 2009 at 9:07 am
#962785
I ran the following query for SQL Server Management Studio "select top 10 * from TESTING as Account for xml auto"
I then clicked on the result and saved it as...
March 19, 2009 at 7:40 am
#962687