Create table, remove records?

From: "vidro" <vidro@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 7 Jul 2005 06:55:09 -0700

SQL 2000;

I have a table that has info from 2001 thru 2005, I want to create new
tables and move records from the original table to the new tables, based on
year.
What is the best way to do this?

.

Follow-Ups:
- Re: Create table, remove records?
  - From: JT

Prev by Date: Re: Normalized Data base
Next by Date: Re: How to Choose Method to Transfer Data from Production to Reporting database
Previous by thread: Front End
Next by thread: Re: Create table, remove records?
Index(es):
- Date
- Thread