<div>
select custtype, count(*) as total<br />
from(<br />
SELECT &nbsp; &nbsp;CustType<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp;Customer<br />
ORDER BY CustType<br />
COMPUTE COUNT(CustType)<br />
) a <br />
group by custtype
</div>


<div>
Hello,<br />
<br />
I am getting this error:<br />
<br />
Msg 156, Level 15, State 1, Line 6<br />
Incorrect syntax near the keyword 'COMPUTE'.<br />
<br />
Any ideas?<br />
Thank you
</div>


<div>
Hello Reb73,<br />
<br />
Good job ! &nbsp; That is it exactly !<br />
<br />
Thanks for the quick response.<br />
<br />
Regards<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a table with customers and a customertype. &nbsp;I would like to get &nbsp;a subtotal of the number of customer types. &nbsp;Here is an example. &nbsp;Note that the &quot;Total&quot; field is not in the database.<br />
<br />
Type &nbsp;Total<br />
Good &nbsp; 100<br />
Bad &nbsp; &nbsp; &nbsp;25<br />
Other &nbsp; &nbsp;9<br />
<br />
Thank you<br />

<pre><code id="code-273498">Here is what I have done so far... IT does give a total, but not a subtotal by Type. 
SELECT    CustType
FROM        Customer
ORDER BY CustType
COMPUTE COUNT(CustType)
</code></pre>
</div>
</div>


I have a table with customers and a customertype.  I would like to get  a subtotal of the number of customer types.  Here is an example.  Note that the "Total" field is not in the database.

Type  Total
Good   100
Bad      25
Other    9

Thank you

select custtype, count(*) as total
from(
SELECT    CustType
FROM        Customer
ORDER BY CustType
COMPUTE COUNT(CustType)
) a 
group by custtype

Hello,

I am getting this error:

Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword &amp;#39;COMPUTE&amp;#39;.

Any ideas?
Thank you

Hello Reb73,

Good job !   That is it exactly !

Thanks for the quick response.

Regards


T-SQL - How to do subtotals?

I have a table with customers and a customertype.  I would like to get  a subtotal of the number of customer types.  Here is an example.  Note that the &amp;quot;Total&amp;quot; field is not in the database.

Type  Total
Good   100
Bad      25
Other    9

Thank you

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.