ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ExecuteAllQueries
ErrorMessage: The column name 'YearGraduated' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'YearGraduated' may appear twice in the view definition.
The column name 'Degree' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Degree' may appear twice in the view definition.
The column name 'CollegeUniversityName' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'CollegeUniversityName' may appear twice in the view definition.
The column name 'YearGraduated' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'YearGraduated' may appear twice in the view definition.
The column name 'Degree' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'Degree' may appear twice in the view definition.
The column name 'CollegeUniversityName' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'CollegeUniversityName' may appear twice in the view definition. INSERT INTO Employee_Payroll(EmployeeID,PayrollScheduleID,EffectiveDate,UserID) Values( 58414, 9 ,'4/4/2018',1); IF NOT EXISTS( SELECT * FROM ImportEmployeeInfoForBackendRoutine WHERE ImportExportBadFileID = 10479 AND EmployeeID = 58414 AND DATEDIFF(DAY, EffectiveDate, '4/4/2018') = 0 AND InsertORUpdate = 1 AND MemberTypeID = 1 ) BEGIN INSERT INTO ImportEmployeeInfoForBackendRoutine (ImportExportBadFileID, EmployeeID, EffectiveDate, InsertORUpdate, MemberTypeID, MemberID, CorePlanStatus, EligibilityStatus) VALUES( 10479, 58414, '4/4/2018' , 1, 1, 58414 , 0, 0 ) END if ( select count(*) from Employee_PostSecondaryInfo where [YearGraduated] = 2004 AND [Degree] = 'BA' AND [CollegeUniversityName] = 'PVT' AND [YearGraduated] = 2009 AND [Degree] = 'BCOM' AND [CollegeUniversityName] = 'KIT' AND [YearGraduated] = 2000 AND [Degree] = 'BE' AND [CollegeUniversityName] = 'sgi' ) = 0 BEGIN INSERT INTO Employee_PostSecondaryInfo(EmployeeID,[YearGraduated],[Degree],[CollegeUniversityName],[YearGraduated],[Degree],[CollegeUniversityName],[YearGraduated],[Degree],[CollegeUniversityName],EffectiveDate,UserID) Values( 58414, 2004 ,'BA','PVT', 2009 ,'BCOM','KIT', 2000 ,'BE','sgi','4/4/2018',1); END