title: On insert: Subquery returned more than 1 value
body: <p>I am trying to insert in to table all those rows which are not in the xml file. When there are more than row it shows me the error: <b>"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used as an expression."</b> This is the query what I am using: </p>
  
  <pre><code>insert into #tmpPievVNC
      select
          a.id, 'J'
      from
          openxml(@hDoc, '/art_kompl/nol_voav') with #vc xd 
          join nol_art a on xd.id_art = a.id
      where
              not exists(select * from nol_voav nv 
          where
              (id_art=xd.id_art) and (begDate=xd.begDate) and (endDate=xd.endDate))
  </code></pre>
  
  <p>How do I insert multiple rows there?</p>