Home Forums SQL Server 2005 Development I need to create an XML file populated by fields data(eg: SQL Server DB table) RE: I need to create an XML file populated by fields data(eg: SQL Server DB table)

  • Select Query for the above DDL

    SELECT [Unique_Seq_Ref_number]

    ,[Record_Type_Flag]

    ,[Reporting_Firm_Identification]

    ,[Reporting_Firm_Code_Type]

    ,[Trade_Date]

    ,[Trade_Time]

    ,[Buy_Sell_Indicator]

    ,[Trading_Capacity]

    ,[Instrument_identification]

    ,[Instrument_Identifier_Type]

    ,[Instrument_Description]

    ,[Underlying_Instrument_Identification]

    ,[Instrument_Type]

    ,[Maturity_exercise_delivery_date]

    ,[Derivative_type]

    ,[Put_call_Identifier]

    ,[Strike_price]

    ,[Price_multiplier]

    ,[Unit_price]

    ,[Price_notation]

    ,[Quantity]

    ,[counterparty_code]

    ,[Counterparty_code_type]

    ,[Venue_Identification]

    ,[Transaction_reference_number]

    ,[Report_status]

    ,[Client_Counterparty_2_code]

    ,[Client_code_type]

    ,[Venue_Identification_code_type]

    ,[Unit_price_type_code]

    ,[Reserved]

    ,[End_of_Record]

    ,[FileName]

    ,[Transaction_status]

    FROM [FSAReportDB].[dbo].[FSA_REPORT_DATA]