Click here to Skip to main content
15,920,438 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
HTML
<group>
    <item text="Products" groupimageurl="~/Img/interior.png" imageposition="1">
      <group>
        <item text="Furniture">
          <group>
            <item text="Tables and Chairs" />
            <item text="Sofas" />
            <item text="Occasional Furniture" />
            <item text="Childerns Furniture" />
            <item text="Beds" />
          </group>
        </item>
        <item text="Decor">
          <group flow="Vertical">
            <item text="Bed Linen" />
            <item text="Throws" />
            <item text="Curtains and Blinds" />
            <item text="Rugs" />
            <item text="Carpets" />
          </group>
        </item>
        <item text="Storage">
          <group flow="Vertical">
            <item text="Wall Shelving" />
            <item text="Kids Storage" />
            <item text="Baskets" />
            <item text="Multimedia Storage" />
            <item text="Floor Shelving" />
            <item text="Toilet Roll Holders" />
            <item text="Storage Jars" />
            <item text="Drawers" />
            <item text="Boxes" />
          </group>
        </item>
        <item text="Lights">
          <group flow="Vertical" offsetx="-26">
            <item text="Ceiling" />
            <item text="Table" />
            <item text="Floor" />
            <item text="Shades" />
            <item text="Wall Lights" />
            <item text="Spotlights" />
            <item text="Push Light" />
            <item text="String Lights" />
          </group>
        </item>
      </group>
    </item>
  </group>


This is my XML data. This data converted in Sql Server 2008.

Thank You.
Posted
Updated 4-Apr-13 1:17am
v2

1 solution

THis seems viable to your problem:
http://stackoverflow.com/questions/3989395/convert-xml-to-table-sql-server[^]

If not lots more found here[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900