Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  XML parsing

Author  Topic  heman_t Starting Member 1 Post Posted - 2007-09-08 : 00:23:29 How can i do this <Root> <A1 time = "x1"> <B1> 1</B1> <C1> 2</C1> <D1> 3</D1> <E1> 4</E1> </A1> <A2 time = "x2"> <B2> 5</B2> <C2> 6</C2> <D2> 7</D2> <E2> 8</E2> </A2> <A2 time = "x3"> <B2> 9</B2> <C2> 10</C2> <D2> 11</D2> <E2> 12</E2> </A2> <A1 time = "x4"> <B1> 13</B1> <C1> 14</C1> <D1> 15</D1> <E1> 16</E1> </A1> </Root> Desired result A1 A2 B1 C1 D1 E1 B2 C2 D2 E2 x1 NULL 1 2 3 4 NULL NULL NULL NULL NULL x2 NULL NULL NULL NULL 5 6 7 8 NULL x3 NULL NULL NULL NULL 9 10 11 12 x4 NULL 1 3 14 15 16 NULL NULL NULL NULL Thanks