title: SQL OpenQuery with Recursive CTE
body: <p>I have the following Recursive CTE which is used in an OpenQuery function in SQL.
  I use OpenQuery to query a SQL Linked Server.</p>
  
  <p>(DOES NOT WORK)</p>
  
  <pre><code>SELECT * FROM OPENQUERY([MyLinkedServerDB], 'WITH SPChainCTE (NAME, INHERIT_FROM) 
  AS
  (
      Select sp.NAME, sp.INHERIT_FROM from PRODUCT AS sp
      where NAME = ''ProductName''
      UNION ALL
      Select sp.NAME, sp.INHERIT_FROM from PRODUCT AS sp
      INNER JOIN SPChainCTE AS ch on sp.NAME = ch.INHERIT_FROM
  )
  Select NAME, INHERIT_FROM from SPChainCTE;
  ');
  </code></pre>
  
  <p>The Above CTE does not work.</p>
  
  <p>However if I execute a non recursive CTE using OpenQuery it works fine.
  (This works)</p>
  
  <pre><code>SELECT * FROM OPENQUERY([FP], 'WITH SPChainCTE (NAME, INHERIT_FROM) 
  AS
  (
      Select sp.NAME, sp.INHERIT_FROM from ENG.FOCALPOINT.SW_PRODUCT AS sp
      where sp.NAME = ''ProductName''
  
  )
  Select NAME, INHERIT_FROM from SPChainCTE;
  ');
  </code></pre>
  
  <p>Any suggestions? Am I missing something here?</p>