title: MSSQL PIVOT - Incorrect syntax. Expecting ID or QUOTED_ID
body: <p>The following code</p>
  <pre><code>select orgUnitNum,  [2020-12-25], [2020-12-26], [2020-12-27], [2020-12-28], [2020-12-29], [2020-12-30], [2020-12-31], [2021-01-01] 
  FROM (select * from @myTable) as source 
  PIVOT (
      max(logincount)
      FOR [logindate] IN ( [2020-12-25], [2020-12-26], [2020-12-27], [2020-12-28], [2020-12-29], [2020-12-30], [2020-12-31], [2021-01-01])
  ) as pivot;
  </code></pre>
  <p>is producing the following error :</p>
  <blockquote>
  <p>Incorrect syntax near 'pivot'.  Expecting ID, or QUOTED_ID.</p>
  </blockquote>
  <p>By all good will, I dont see any syntax error there.</p>
  <p>Can you spot anything?</p>