Select a record, then Insert same record but diff data 1

[JohnnyLong]

Hi Everyone,

Can somebody please tell me how to SELECT a record from a table and then INSERT the same record to the same table but with a small change to the data.

Like this:

SELECT *
FROM rc_Events
WHERE ContactID = 10038214

INSERT
INTO rc_Events(EventType, Subject, ClientID, CandidateID,OrderID, ContactID, PlacementID, InterviewID, CVID, ReferenceID, CompletedFlag, CreatedDate, CreatedBy,
ModifiedDate, ModifiedBy)
VALUES (EventType, Subject, ClientID, CandidateID, OrderID,
10038295, PlacementID, InterviewID, CVID, ReferenceID,
CompletedFlag, CreatedDate, CreatedBy, ModifiedDate,
ModifiedBy)

rc_Events has an Identity increment of 1

I'm basically trying to Insert a 'copy' of a record but with a different ContactID.

This is in SQL 7

Thanks,

John

 

[Katy44]

insert into rc_Events
(
EventType, Subject, ClientID, CandidateID, OrderID,
ContactID, PlacementID, InterviewID, CVID, ReferenceID,
CompletedFlag, CreatedDate, CreatedBy, ModifiedDate,
ModifiedBy
)
(select EventType, Subject, ClientID, CandidateID, OrderID,
10038295, PlacementID, InterviewID, CVID, ReferenceID,
CompletedFlag, CreatedDate, CreatedBy, ModifiedDate,
ModifiedBy FROM rc_Events
WHERE ContactID = 10038214)

Hope this works.
If this will be a regular thing you may want to create a stored procedure where you pass in the contactid f the record you want to copy, and what you want its new ccontactID to be.