one xml element (with children) to many table rows

[Verusanct]

I need to turn the following XML structure into the following table structure (in SQL Server 2000)\[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>\[/code\]Sample data in table:\[code\]parent_id child1 test11 test22 test32 test4\[/code\]Query:\[code\]SELECT Child FROM OPENXML (@hdoc, 'family/parent/child') WITH(Child nvarchar(256) '.')\[/code\]gives result:\[code\]test1test2test3test4\[/code\]Query #2:\[code\]SELECT ParentID, Child FROM OPENXML (@hdoc, 'family/parent') WITH( Child nvarchar(256) 'child/.', ParentID int 'id/.' )\[/code\]gives result:\[code\]1 test12 test3\[/code\]How do I get both parent id and all children?