select * from tbl_DST_Distributors insert into tbl_DST_Distributors ( dstId, dstname, dstshortname, dstbranchId, dstcompanytype, dstparentco, dstsaleschannel, dstdisttype, dstsptycat, dstbuyinggrp, dstbuyinggrp2, dstaddr1, dstaddr2, dstcity, dststate, dstzip, dstcountryid, dstphoneac, dstphone, dstfaxac, dstfax, dsturl, EmailDomain, dstlogo, dstprofile, dstkeywords, dstcomments, dstlastupdate, dstlastupdatenotes, dstpubtrade, dstexchsymbol, dstprofileready, recordlock, fsrDistributorshipId, fsrBusName, fsrBusUnitName, fsrBusAddr1, fsrBusAddr2, fsrBusAddr3, fsrBusCity, fsrBusState, fsrBusPostalCode, fsrBusCountry, fsrMappedOn, fsrMappedBy, fsrLoadedOn, gs1_gln, profileUpdated, profileConfirmedBy, profileConfirmedDate, dstMarketName, allowPrivateLabel, uniformBranchCodes, dunsId, dstMarketId, dstRDCId ) select dstId, dstname, dstshortname, dstbranchId, dstcompanytype, dstparentco, dstsaleschannel, dstdisttype, dstsptycat, dstbuyinggrp, dstbuyinggrp2, dstaddr1, dstaddr2, dstcity, dststate, dstzip, dstcountryid, dstphoneac, dstphone, dstfaxac, dstfax, dsturl, EmailDomain, dstlogo, dstprofile, dstkeywords, dstcomments, dstlastupdate, dstlastupdatenotes, dstpubtrade, dstexchsymbol, dstprofileready, recordlock, fsrDistributorshipId, fsrBusName, fsrBusUnitName, fsrBusAddr1, fsrBusAddr2, fsrBusAddr3, fsrBusCity, fsrBusState, fsrBusPostalCode, fsrBusCountry, fsrMappedOn, fsrMappedBy, fsrLoadedOn, gs1_gln, profileUpdated, profileConfirmedBy, profileConfirmedDate, dstMarketName, allowPrivateLabel, uniformBranchCodes, dunsId, dstMarketId, dstRDCId from FSLibrary..tbl_DST_Distributors where dstId =