SQLTeam.com | Weblogs | Forums

Move selected record from one table to another newly created table

Hello,
which is the best way to move selected record from a table to a new table?

For example:

Select Sept records from myTable (real), copy them to a new table ("Table_Sept" for example), e delete them from the original one.

Luis