====== Microsoft - Microsoft SQL Server - SQL - Tables - Copy into existing Table ======

<code sql>
Insert Into dbo.ztVenDedup
   Select * 
   From dswMatchReview_Backup.dbo.ztVenDedup_Backup_20210615_000030
</code>

----

<code sql>
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;
</code>