Database Admin. :  Student Freelance Forum For Work Experience Builders' (CertificationPoint) The fastest message board... ever.
 
Insert Statement
Posted by: adcertpoint (Moderator)
Date: July 02, 2017 01:28AM

Hello everyone long time no see I hope everyone is doing well.

I have an insert statement that I need to make sure is correct. Its been awhile since I've done one. the table that I'm inserting the lost data into a table that has well over 100,000 records, the table that I'm pulling data from has 446 records i just want to make sure I insert all of them with no errors

Code:

SET IDENTITY_INSERT dbo.TanfActivity_tbl on

INSERT INTO dbo.TanfActivity_tbl
(ID, EventDate, [Parent ID], PurposeofContact, TypeofContact, ReferralDate, Earnedhours, ServicesCovered, Catagoryforhours, StateCatagory, Month,
Week, StateServicesCovered, TanfID, PeopleID, ScairCaseWorker, MERCodes, NameofWorkshop, EventName, EventLocation, Education, Culture,
Technology, Prevention, Safety, LifeSkills, YouthLeadership, Health_Fitness, TypingSpeed, MaximumScore, PassingScore, ParticipantsScore,
AbsentDate, PracticeTestMode, CompletionPercentage, TypingAccuracy, TravelTime, Absent)
SELECT ID, EventDate, [Parent ID], PurposeofContact, TypeofContact, ReferralDate, Earnedhours, ServicesCovered, Catagoryforhours, StateCatagory, Month,
Week, StateServicesCovered, TanfID, PeopleID, ScairCaseWorker, MERCodes, NameofWorkshop, EventName, EventLocation, Education, Culture,
Technology, Prevention, Safety, LifeSkills, YouthLeadership, Health_Fitness, TypingSpeed, MaximumScore, PassingScore, ParticipantsScore,
AbsentDate, PracticeTestMode, CompletionPercentage, TypingAccuracy, TravelTime, Absent
FROM dbo.EstradaTanfActive

SET IDENTITY_INSERT dbo.TanfActivity_tbl on

Options: ReplyQuote


Sorry, only registered users may post in this forum.
This forum powered by Phorum.