declare @xdoc xml
set @xdoc = '
<StoreProc>
<Proc id="GSYYZYGDEJSCHZ" desc="重要股东二级市场交易-汇总" name="P_TJ_ZYGDEJSC_HZ" cachemin="20">
<Param name="SDate" ascachename="true"></Param>
<Param name="EDate" ascachename="true"></Param>
</Proc>
<Proc id="HQSTATDRTJ" desc="行情统计当日统计" name="SP_jrj_hqstat_today" cachemin="10">
</Proc>
<Proc id="HQSTATDRTJ" desc="行情统计当日统计" name="SP_jrj_hqstat_today" cachemin="10">
</Proc>
</StoreProc>
'
select t.c.value('@id', 'varchar(255)') as c1 ,t.c.value('@desc', 'varchar(255)') as c2
into #T from @xdoc.nodes('/StoreProc/Proc') t (c)
select * from #T
select c1 from #T group by c1 having count(c1)>1
drop table #T