There are 4000 entries currently and growing every check we write go's into one of the two tables.
-----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:09 PM To: CF-Talk Subject: RE: table union I'm not sure about temp tables in access. If my temp table you really just mean creating a regular table which you will drop when you are done that would not allow for concurrent executions of your code since they would be using the same table. (temp tables in SQL Server are connection specific I believe) There are ways around that, like having a unique number per process, but you are kind of defeating part of you purpose at that time. How many records are you dealing with? ~Brad ion.com/cf_lists/unsubscribe.cfm?user=30316.21480.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
