title: SQL 2008 VS 2012 Error: Incorrect syntax near the keyword 'COMPUTE'
body: <p>My friend sent me the commands that he wrote in server 2008 and they worked with no problems, mine however from a copy and past did not work with 2012. Is there any reason why? Here is the code:</p>
  
  <pre><code>        Use Kudler_Database
          SELECT  AccountNumber, [Description], ShortDescription,Balance
          FROM Chart_of_Accounts 
          ORDER BY left (AccountNumber, 2)
          COMPUTE SUM(Balance) BY left (AccountNumber, 2)
          COMPUTE SUM(Balance); 
  </code></pre>
  
  <p>Here is the error :</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword
    'COMPUTE'.</p>
  </blockquote>