in reply to Help Copying records from one table to another.
(assuming the column names are the same - otherwise, just substitute the proper column names).select BulletinID, CVENumber, Title, DatePosted, DateRevised, Supported, Summary, Issue, ImpactSeverityID, PreReqSeverityID, MitigationSeverityID, PopularityID from dbo_Bulletins into knownbulletins
This should be much faster than passing everything through a Perl program.
Abigail
|
|---|