Probably a simple question but say I have a table. I wish to copy the
structure of that table into a new table (in the same database).
From there I wish to move certain records from the original table, for
example all records before a certain date into this new table.
Can anyone point me in the right direction? I'm unsure as to how to do this?
Is there a T_SQL command?
As regards the second I assume that I would use an INSERT .... SELECT
statement to copy the relevent values into the new table, followed by a