Copy Data out of Table in an other Table within same DB

[Marcel Stoop]

Hi

I've got a small Problem. I want to copy several rows out of (Ms SQL) Table
A into Table B. Table A and B are the same and are within the same DB
Is that possible?

Thanks for the help

Marcel

 

[Norman Yuan]

Simply run a "INSERT INTO ...SELECT ..." query.

For example:

INSERT INTO tblA (Field1,Field2,...) SELECT Field1,Field2,... FROM tblB
WHERE <your condition>

 

[Marcel Stoop]

Thanks for the help.

Marcel

Simply run a "INSERT INTO ...SELECT ..." query.

For example:

INSERT INTO tblA (Field1,Field2,...) SELECT Field1,Field2,... FROM tblB
WHERE <your condition>