It would be in your best interest to run one query and sort it ascending by date in order to achieve the same effect with one query, which is ultimately faster. Unless there is a good reason why using one query is undesirable....
-dhs On Monday, December 30, 2002, at 01:14 PM, [EMAIL PROTECTED] wrote: > I have a query that needs to loop through 1991 to 2001. Is it > possible to write > a store procedure that will loop through the years and run the query > each time? > Something that would be the equivalent of a for loop or forall. > > Thanks, > > Zeina > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
