Counts are usually fairly quick if done on key fields. You can combine all your little queries into a single query by using sub-queries. Either way the DB is going to have to do the work, when you need it, or on a continuous basis. Sub-queries might be a good alternative to consider.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 11:55 AM To: SQL Subject: Re: Question on views Derrr. Using MS SQL Server. *bonk* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2754 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
