I think one of the most asked and answered questions in SQL (not just SQL Server, but SQL engines in general) is "How do I find/get the data from table A to table B?" In fact, you've probably seen multiple variations of the question and the answer. I have a script or two in my toolbox just for that, but I have to say that Jamie Thompson has one of the most in-depth treatments of the subject. The interesting thing about his entry is that in addition to the usual suspects of Transact-SQL answers, he also uses...SQL Server Integration Services. Not sure if this is over-engineering, but it sure is interesting!