pappagallauers
New Member
I have following XML, and i wish to save its data in my SQL table. I have a table named as tblDummy it has three columns "JobID" "ItemID" "SubitemID". there can be multiple subitemsid for particular combination of Jobid and Itemid. How can i do this?\[code\]<jobs> <job> <jobid>4711</jobid> <items> <itemid>1</itemid> <subitems> <subitemid>1</subitemid> <subitemid>2</subitemid> </subitems> <itemid>2</itemid> <subitems> <subitemid>7</subitemid> <subitemid>10</subitemid> </subitems> <itemid>9</itemid> <subitems> <subitemid>12</subitemid> <subitemid>16</subitemid> </subitems> </items> </job> </jobs>\[/code\]