ASP/SQL Question

[SyrOrange]

I have an SQL command and recordset using ASP

<%
strSQL = "SELECT Count(*) AS MonitorsDeployed FROM Monitors Where
Status='Deployed'"
rs.Open strSQL, conn, 3, 3
response.write(rs("MonitorsDeployed"))
%>

Is there a way to have create variables based on other criteria or do I need
a separate recordset for each one.

For example, I have monitors with status' of "Deployed", "Storage", "Broken"
and I want the count of these. Is there an easier way?

 

[Ray Costanzo [MVP]]

SELECT COUNT(yourIDcolumn),Status FROM Monitors GROUP BY Status

That should return a recordset like

100 Deployed
29 Broken
45 Storage

Ray at work