title: Joining Two Same-Sized Resultsets by Row Number
body: <p>I have two table functions that return a single column each. One function is guaranteed to return the same number of rows as the other.</p>
  
  <p>I want to insert the values into a new two-column table. One colum will receive the value from the first udf, the second column from the second udf. The order of the inserts will be the order in which the rows are returned by the udfs.</p>
  
  <p>How can I JOIN these two udfs given that they do not share a common key? I've tried using a ROW_NUMBER() but can't quite figure it out:</p>
  
  <pre><code>INSERT INTO dbo.NewTwoColumnTable (Column1, Column2)
  SELECT udf1.[value], udf2.[value]
  FROM dbo.udf1() udf1
  INNER JOIN dbo.udf2() udf2 ON ??? = ???
  </code></pre>