Firiends any one has worked on creating a SQL to generate this kind of XML, Help me please.

Hi Lowell

Can you help me on the query please.

Many thanks

V

Hi

As requested , i have uploaded DDL script to create table and few rows to insert . please help me with SQL query to generate XML.

Many thanks

Hi

Attached XML output file to be generated one more time. If you say i missed/put some extra tags in my first post. it is corrected now.

Many thanks

VJ

Select Query for the above DDL

SELECT [Unique_Seq_Ref_number]

,[Record_Type_Flag]

,[Reporting_Firm_Identification]

,[Reporting_Firm_Code_Type]

...

Hi

Here it is Table structure.

CREATE TABLE [dbo].[FSA_REPORT_DATA](

[Unique_Seq_Ref_number] [int] IDENTITY(1,1) NOT NULL,

[Record_Type_Flag] [int] NULL,

[Reporting_Firm_Identification] [nvarchar](50) NULL,

[Reporting_Firm_Code_Type] [nvarchar](1) NULL,

[Trade_Date] [nvarchar](10) NULL,

[Trade_Time] [nvarchar](8) NULL,

[Buy_Sell_Indicator] [nvarchar](1) NULL,

[Trading_Capacity] [nvarchar](1) NULL,

[Instrument_identification] [nvarchar](50) NULL,

[Instrument_Identifier_Type] [nvarchar](1)...

Hi Friend

I believe you are creating this xml file for FSA report purpose and i have to create the same file. Can you please help me on this.

Many thanks

VJ