Maybe I don't have a clear concept of a numbers table (I'll be reading up on them tomorrow.) but wouldn't I need a "number" to correspond to the units in question (in this case days.)
thx -----Original Message----- From: Mike Chabot [mailto:[email protected]] Sent: Sunday, September 26, 2010 11:42 AM To: cf-talk Subject: Re: cfoutput or cfloop? which is the more practical solution If you go with the numbers table route, I should clarify that this is a standard technique that is commonly used, so you should be able to find a lot of information by searching on "sql server numbers table." I use these all the time. I would think that your numbers table only needs to contain numbers 1900 - 2100 or so, to cover the years someone would be in office. The only purpose the table would have would be to join to the start and end date ranges to create artificial rows that can be grouped on. I suppose you could call your table "years" instead of "numbers." -Mike Chabot On Sat, Sep 25, 2010 at 11:55 PM, GLM <[email protected]> wrote: > > Mike thanks for the lead. It had crossed my mind to build a numbers table > but I didn't think it would work. (I've never used them myself.) > > I thought that it was somewhat excessive as there would have to be at least > 365x220 rows (over 80,000). In the examples I gave I think one row per year > (220) would be more than good enough but there are numerous exceptions > (people dying in office, getting nominated to higher office, etc...) > > I'll give it a shot. > > Thx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
