Invalid object name for cte
<p>I am getting the following error when trying to run this cte</p>

<blockquote>
  <p>Invalid Object Name 'cte'</p>
</blockquote>

<p>error when using the following CTE statement</p>

<pre><code>WITH cte (LOC_ID, [Description], LOC_TYPE)
AS
(
    select LOC_ID, DESCR, LOC_TYPE
    FROM [APOLLO].[dbo].[TBL_STATIC_DATA_LOCATIONS_MERLIVE]
    WHERE LOC_TYPE = 'DC'
) 
select * from cte
</code></pre>

<p>I am using Microsoft SQL Server Management Studio. </p>