Sure, just explicitly list your columns. In fact, I would recommend ALWAYS doing that since if you script a table and the columns get into an different order it will really screw up your insert into table select * stuff.
Just do this: INSERT INTO backup_name (col1,col2,col3,timestamp) (SELECT col1,col2,col3,getdate() FROM source_table WHERE col1 = 'filtervalue') ~Brad ----- Original Message ----- From: "Dan LeGate" <[EMAIL PROTECTED]> To: "cf-talk" <cf-talk@houseoffusion.com> Sent: Thursday, December 04, 2008 2:50 AM Subject: INSERT INTO from another table > 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: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:316239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4