From SQL Server 2005, I have to export to a client in an XML-like format why they are not using XML I do not know. How to do this immediately without exporting the file "X XML" and then writing a filthy script to go through the text file and to find and replace the LTTE, and every XML tag? Thank you.
START_FILE: DATE: COLUMN1: A COLUMN2: B COLUMN3: C COLUMN1: D COLUMN2: E COLUMN3: F COLUMN1: G COLUMN2: H column 3: I END_FILE:
announcement @outputnetwork (maximum) SET @output = 'START_FILE: DATE:' SELECT @Output = @ Output + 'COLUMN1:' + 1 Column + 'COLUMN2:' + 2 Outstanding + 'COLUMN3:' + Select Column 1 with your Tables Order from Col3 @ Output + 'END_FILE:' AS Result '
Comments
Post a Comment