F OBJECT_ID (N'tempdb..#tmpXml ', N'U') IS NOT NULL
DROP TABLE #tmpXml ;

create table #tmpXml
(
ID int IDENTITY(1,1),
Stat xml not null
)


DECLARE @x xml;
SET @x = N'<Root>
<Item>
<SubItem1 v="subitem1.1" >
<action rule="rule 1.1" />
<action rule="rule 1.2" />
</SubItem1>
<SubItem2 v="SubItem1.2" >
<action rule="rule 2.1" />
</SubItem2>
<SubItem3 v="SubItem1.3" >
<action rule="rule 3.1" />
</SubItem3>
<SubItem4 v="SubItem1.4">
<action rule="rule 4.1" />
</SubItem4>
</Item>

</Root>
'
insert into #tmpXml (stat) values(@x)


SET @x = N'<Root>
<Item>
<SubItem1 v="subitem2.1" >
<action rule="rule 1.1" />
<action rule="rule 1.2" />
</SubItem1>
<SubItem2 v="subitem2.1" >
<action rule="rule 2.1" />
</SubItem2>
<SubItem3 v="subitem2.1" >
<action rule="rule 3.1" />
</SubItem3>
<SubItem4 v="subitem2.1">
<action rule="rule 4.1" />
</SubItem4>
</Item>
</Root>
'
insert into #tmpXml (stat) values(@x)