I have a query:
我有一个问题:
insert into #tmpRcIzm
select distinct
v.id_art, 'Y'
from
openxml(@hDoc, '/art_komp/nol') with #vc xd
inner join nol v on xd.id_art = v.id_art
where
xd.P_REF!=v.P_REF
insert into #tmpRcI