transfering records between tables

[borgkling2003]

I need a script to tranfer record from TABLE A to TABLE B on an SQL command when an ASP page is uploaded.

eg Select * from TABLE A where REGISTERED ="T"

Both tables are of the same structure.

Does anyone know how to do it?

 

[theniteowl]

insert into mynewtable select * from TABLE A where REGISTERED = "T"

It's an easy query. But you do have to know that the new table is either empty to start with or that the incoming data is not going to conflict with existing data in fields that disallow duplicate records.



Stamp out, eliminate and abolish redundancy!

 

[DotNetGnat]

one small correction:

insert into TableB 
select * from TABLE A where REGISTERED = [red]'T'[/red]

watch out for duplicate ids...

-DNG