title: Row_Number() continue in Union query
body: <pre><code>;WITH CTE AS
  (
  Select * From
          (
          SELECT ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo, FirstName
  From Tab1
    UNION ALL
     SELECT ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo, FirstName
     From Tab2
  ) v
  )
  Select * From CTE
  </code></pre>
  
  <p>Is there anyway I could continue after the <code>Row_Number()</code> generated in Tab1. So if 1st result in <code>UNION</code> ended at 10000 the 2nd table in UNION should start from 10001</p>
  
  <p><strong>Note:</strong> I want the <code>Row_Number()</code> as it is inside the <code>Select * From</code></p>
  
  <p>Thus I don't can't change it to:</p>
  
  <pre><code>;WITH CTE AS
  (
  Select *, ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo From
          (
          SELECT FirstName
  From Tab1
    UNION ALL
     SELECT FirstName
     From Tab2
  ) v
  )
  Select * From CTE
  </code></pre>
  
  <p>Any help is greatly appreciated.</p>