UPDATE cdr SET cdr.mfr_bsr_id = , cdr.setMethod = 3 , cdr.setMethod = 5 FROM tbl_CDR_Distributors cdr WHERE cdr.cdr_recordId = AND cdr.ownerid = AND cdr.fsl_tablecode = UPDATE tbl_CDR_Distributors SET cdr_dstname = , cdr_dstaddress1 = , cdr_dstaddress2 = , cdr_dstcity = , cdr_dststate = , cdr_dstzip = , cdr_dstcountryID = , cdr_dstcompanytype = , comments = , cdr_territoryid = , mfr_bsr_id = 0 , setMethod = 3 , mfr_bsr_id = , setMethod = 5 , setMethod = 1 , classificationId = , primaryContactId = WHERE OwnerID = AND FSL_TableCode = AND cdr_recordid = SET NOCOUNT ON INSERT INTO tbl_CDR_Distributors(OwnerID, FSL_TableCode, cdr_dstname, cdr_dstaddress1, cdr_dstaddress2, cdr_dstcity, cdr_dststate, cdr_dstzip, cdr_dstcompanytype, comments, cdr_territoryid, cdr_dstcountryID) VALUES (, , , , , , , , , , , ) SELECT NewDistributorID = @@identity SET NOCOUNT OFF