Was just reading how to do an INSERT INTO from another table in SQL Server 2000 (like SELECT INTO, but without creating a new table) like this:
INSERT INTO tablename (the table you want to copy into) SELECT * from tablename (the table you want to copy from) WHERE Field = (some condition) and wanted to know if I could add a field (like a date/time stamp) of when this data was inserted as part the same query? If not, is there an equivalent in CF7 for result_name.IDENTITYCOL type of variable after an insert? Something at the Java level perhaps? My ultimate goal is to backup a row of data from one table to another, and also add a datestamp of when it was backed up to that table. I'd like to have an extra field in the target "backup" table that can hold the datestamp, but it appears INSERT INTO won't work unless the target table has the exact same fields (and no "extra" fields - not sure why it cares about that). Is there a better way to do this? I was hoping to keep the copy "in the database" instead of selecting fields into CF variables, and then inserting those, but I'll do that if necessary. Thanks, Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
