Hello,
I have this web application running and I need to export the data in specific XML format given.
I'm giving you an example of one table to be more specific.
- CREATE TABLE [dbo].[TEST](
- [Id] [int] IDENTITY(1,1) NOT NULL,
- [Code] [int] NULL,
- [A] [decimal](6, 2) NULL,
- [B] [decimal](6, 2) NULL,
- [C] [decimal](6, 2) NULL,
- [D] [decimal](6, 2) NULL,
- [E] [decimal](6, 2) NULL,
- [F] [decimal](6, 2) NULL,
- [G] [decimal](6, 2) NULL,
- [H] [decimal](6, 2) NULL,
- CONSTRAINT [PK_TEST] PRIMARY KEY CLUSTERED([Id] ASC))
The XML output must be like the following:
- <table t="TEST">
- <group g="A">
- <u val=**column code value**>
- <col c="A">
- <value>**value of column A**value>
- col>
- <col c="B">
- <value>**value of column B**value>
- col>
- <col c="C">
- <value>**value of column C**value>
- col>
- <col c="D">
- <value>**value of column D**value>
- col>
- u>
- group>
- <group g="B">
- <u val=**column code value**>
- <col c="E">
- <value>**value of column E**value>
- col>
- <col c="F">
- <value>**value of column F**value>
- col>
- u>
- group>
- <group g="C">
- <u val=**column code value**>
- <col c="G">
- <value>**value of column G**value>
- col>
- <col c="H">
- <value>**value of column H**value>
- col>
- u>
- group>
- table>
Thank you in advance.
Chriz LPosted Aug 18, 2017, 1:43 AM
Gokhul VarmanPosted Aug 17, 2017, 9:27 AM