Question: how to copy data from one table to another sql server 2008?
Answer: Right Click on the Database -> Tasks -> Export Data. Select the source/target Database. Select source/target table and fields. Copy the data.