<quote> Our DBA created a days table with days and weekending column from 2002 until 2009 for us... That would have made it a lot simpler, heh. And it's not all that large either. 2922 rows, 2 columns.. not large at all.
Then you could have done it all within SQL and not have to rely on CF. </quote> That was proposed, but for some reason, it did not go over with our senior DBA. Yes it would have been easier. Ours would have to be a bit bigger. The date range would have to be 1987 or so to some time in the future. But still would have been easier. The ultimate solution IMHO is a stored procedure. But no one here has created stored procedures that return record sets. So this solution is a good stop gap until I can figure out the stored procedure solution. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
