*********** REPLY SEPARATOR ***********
On 2/1/00, at 11:53 AM, Josh Hillman wrote:
>Here's something...
>
>SELECT City, ZIP, MBRs=3Dcount(Zip)
>FROM MasterAccounts
>WHERE Active =3D 1 /* Display only "active" people) */
>GROUP BY City, Zip
>ORDER BY City, Zip
>
>----- Original Message -----
>From: PowerNet <psc5@powersupply.net>
>To: <emerald@iea-software.com>
>Sent: Tuesday, February 01, 2000 10:04 AM
>Subject: [Emerald] SQL QUERY
>
>
>I need a list of zip codes I service and # of users by zip.
>
>We are using Emerald/RadiusNt with SQL 6.5
>
>I am looking for a nice little script that will show me Town, Zip code and=
#
>of users per.
>
>I would be happy to see any script close also.
>
>Thanks,
>John
>
>
>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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart