I get about the same time using the QoQ... you would not think it was this hard to join two tables together lol Would making an additional table to keep all the info in and writing each check transaction to both tables Then pull the report off the master table?
-----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 4:31 PM To: CF-Talk Subject: RE: table union No arrays necessary. You should be able to union the two result sets with a query of queries after running them separately. The database _should_ always be the fastest way to do that, but obviously there are some other factors at work here and I don't know how to trouble shoot them... If you have SQL server sitting around and you are just waiting to use it-- heck go for it. It's always harder to switch later. I don't know that I would spend the money just for the heck of it unless you definitely need some of its functionality or you are planning on having a pretty big database by the time you are done with app. I used to do all my personal stuff in Access because it was all I had. I've worked for 3 1/2 years with MS SQL 2000 and 2005 now and I don't think I could go back now that I am used to it. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
