[dba-SQLServer] Count of records with zip

John W. Colby jwcolby at colbyconsulting.com
Tue Sep 21 13:35:52 CDT 2004


I need what appears to me to be a crosstab, a COUNT of all records in a set
of zip codes.  In other words, I have a table of zips (about 100).  I need a
count of how many records in my nVLDB is in each zip code.  Can anyone point
me in the right direction in SQL Server?

John W. Colby
www.ColbyConsulting.com 





More information about the dba-SQLServer mailing list