> From: Ed Miller <emiller@del.net>
> > Does someone have a SQL script that can tell me how many
> > accounts I have in each type of account?
> > We have someone that is interested in buying our dialup accounts,
> > (A new each week ;-) and I wpuld like to have a list broken
> > down by type.
>
> How's this for a basic one?:
>
> SELECT AccountType,
> Total=count(CustomerID)
> FROM subaccounts
> WHERE Active = 1
> GROUP BY AccountType
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart