| SQL |
insert into tbl_CDR_Distributors (ownerId, fsl_tableCode, cdr_dstName, cdr_dstAddress1, cdr_dstAddress2, cdr_dstcity,
cdr_dststate, cdr_dstzip, cdr_dstCountryId, cdr_dstmarketinggrp, cdr_territoryId, fsl_dstId, recState, setMethod,
mfr_bsr_id, crmActive,FocusAccount,classificationId, fseTerritoryIdStatus, cdr_priority, useSysFields, hasSysFields, cdr_dstPath,
cdr_dstCode, cdr_dstcompanyType, fsl_masterlinkYN, cdr_specialAcctType, cdr_redistAcctFor, recordSource, createDate
)
select ownerId, fsl_tableCode, cdr_dstName, cdr_dstAddress1, cdr_dstAddress2, cdr_dstcity, cdr_dststate, cdr_dstzip,
cdr_dstCountryId, cdr_dstmarketinggrp, cdr_territoryId, fsl_dstId, recState, setMethod, mfr_bsr_id, crmActive,FocusAccount,
classificationId, fseTerritoryIdStatus, cdr_priority, useSysFields, hasSysFields, cdr_dstPath ,
'' cdr_dstCode, 'S' cdr_dstcompanyType, 'N' fsl_masterlinkYN, 'RDA' cdr_specialAcctType, 0 cdr_redistAcctFor, '' recordSource, getDate() createDate
from tbl_CDR_Distributors redist with (nolock)
where ownerId = 387
and fsl_tablecode = 'BRO'
and cdr_recordId = 21916
|