Robert Rawlins - Think Blue wrote: > > What would you suggest as a Staging Table? Does SQL Server have a specific > function for creating this temporary table? Or do I need to build and drop > one myself? > > What would you suggest?
I prefer to make data loading / transformation tables permanent tables in their own schema. That way they are always accessible for schema inspection and I can create a log table in the same schema too. And if something goes wrong halfway the data will still be accessible, while temporary table are generally not accessible after the transaction has been aborted. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
