SQLServerCentral / SQL Server 2012 / SQL Server 2012 - T-SQL / COMPUTE Clause problem / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:38:58 GMT20RE: COMPUTE Clause problemhttp://www.sqlservercentral.com/Forums/Topic1431382-3077-1.aspxWe're in a 2012 Forum so I'll assume SQL 2012. Support for COMPUTE was dropped from SQL Server 2012 and is not available under any compatibility mode. Use ROLLUP instead.[url]http://technet.microsoft.com/en-us/library/ms144262.aspx[/url]Fri, 15 Mar 2013 19:57:08 GMTopc.threeRE: COMPUTE Clause problemhttp://www.sqlservercentral.com/Forums/Topic1431382-3077-1.aspx[quote][b]ChrisM@Work (3/15/2013)[/b][hr]What version of SQL Server are you connected to?[/quote]And what compatibility level is set for the database?Fri, 15 Mar 2013 07:00:07 GMTHowardWRE: COMPUTE Clause problemhttp://www.sqlservercentral.com/Forums/Topic1431382-3077-1.aspxWhat version of SQL Server are you connected to?Fri, 15 Mar 2013 03:27:34 GMTChrisM@WorkCOMPUTE Clause problemhttp://www.sqlservercentral.com/Forums/Topic1431382-3077-1.aspxHI [code="sql"]SELECT SalesOrderID, UnitPrice, UnitPriceDiscountFROM Sales.SalesOrderDetailWHERE SalesOrderID = 43659ORDER BY SalesOrderIDCOMPUTE SUM(UnitPrice), SUM(UnitPriceDiscount) BY SalesOrderID;[/code]Above query is giving below error [quote]Incorrect syntax near the keyword 'COMPUTE'.[/quote]Fri, 15 Mar 2013 01:21:16 GMTBhuvnesh