title: Types don't match between the anchor and the recursive part in column "DataItem" of recursive query "testtable"
body: <p>I am executing the following statement:</p>
  <pre><code>;WITH testtable(strict,DataItem, description) AS
      (
          SELECT
              strict,
              LEFT(description, CHARINDEX(CHAR(10), description + CHAR(10)) - 1),
              STUFF(description, 1, CHARINDEX(CHAR(10), description + CHAR(10)), '')
          from safezone where id = 12
          UNION all
  
      SELECT
          strict,
          LEFT(description, CHARINDEX(CHAR(10), description + CHAR(10)) - 1),
          STUFF(description, 1, CHARINDEX(CHAR(10), description + CHAR(10)), '')
      FROM testtable
      WHERE
          description &gt; ''
          
  )
  
  
  SELECT
      strict,
      DataItem
  into testno FROM testtable
  ORDER BY strict
  option (maxrecursion 0)
  </code></pre>
  <p>...which finishes with the error...</p>
  <blockquote>
  <p>Types don't match between the anchor and the recursive part in column &quot;DataItem&quot; of recursive query &quot;testtable&quot;.</p>
  </blockquote>
  <p>Where am I making the mistake?</p>