one xml element (with children) to many sql 2000 table rows

[Murph]

I need to turn the following xml structure into the following table structure (in SQL2000)\[code\]<family> <parent> <id>1</id> <child>test1</child> <child>test2</child> </parent> <parent> <id>2</id> <child>test3</child> <child>test4</child> </parent></family>parent_id child1 test11 test22 test32 test4SELECT Child FROM OPENXML (@hdoc, 'family/parent/child') WITH(Child nvarchar(256) '.')gives:test1test2test3test4SELECT ParentID, Child FROM OPENXML (@hdoc, 'family/parent') WITH( Child nvarchar(256) 'child/.', ParentID int 'id/.' )gives:1 test12 test3\[/code\]How do I get both parent id and all children?