INSERT INTO dbo.ztVenDedup SELECT * FROM dswMatchReview_Backup.dbo.ztVenDedup_Backup_20210615_000030
TRUNCATE TABLE dbo.ztStructureCleansing; INSERT INTO dbo.ztStructureCleansing SELECT zSource, KeyField, zSystem, zObject, SetField01, sField01, Field01, dField01, zField01, SetField02, sField02, Field02, dField02, zField02, SetField03, sField03, Field03, dField03, zField03, SetField04, sField04, Field04, dField04, zField04, SetField05, sField05, Field05, dField05, zField05, SetField06, sField06, Field06, dField06, zField06, SetField07, sField07, Field07, dField07, zField07, SetField08, sField08, Field08, dField08, zField08, SetField09, sField09, Field09, dField09, zField09, SetField10, sField10, Field10, dField10, zField10, Comment, zConfirmed, zConfirmedOn, zConfirmedBy, zRejected, zRejectedOn, zRejectedBy, zReviewComment, AddedBy, AddedOn, AddedVia, ChangedBy, ChangedOn, ChangedVia, boaStatus, BatchID, JobExecutionDate, zActive, zCDelta, zCDeltaOn, zCDeltaBy, SourceExtractDate, ExecutionDate, zEmployee, CATEG FROM dbo.ztStructureCleansing_Snapshot_20210622_184721;