I needed something similar for an archive routine and wrote this sproc, which is completely generic and dynamic in nature. I've tested it on a table with over 5 million...