SELECT cdr.cdr_dstname, cdr.mfr_bsr_id, cdr.cdr_priority,cdr.classificationid, c.description classification, cdr.mfr_bsr_id2 FROM tbl_CDR_Distributors cdr LEFT OUTER JOIN tbl_CDR_Classifications c ON (cdr.classificationid = c.classificationID) WHERE cdr.cdr_recordId = AND cdr.ownerid = AND cdr.fsl_tablecode = UPDATE cdr SET cdr.mfr_bsr_id = , classificationId = , cdr_priority = , utcTimeStamp = getDate(), utcSyncTime = null , cdr.setMethod = 3 , cdr.setMethod = 5 FROM tbl_CDR_Distributors cdr WHERE cdr.cdr_recordId = AND cdr.ownerid = AND cdr.fsl_tablecode = UPDATE cdr SET cdr.mfr_bsr_id2 = , cdr.setMethod2 = 3 , cdr.setMethod2 = 5 FROM tbl_CDR_Distributors cdr WHERE cdr.cdr_recordId = AND cdr.ownerid = AND cdr.fsl_tablecode = SELECT cdr.cdr_dstname, cdr.mfr_bsr_id, cdr.cdr_priority,cdr.classificationid, c.description classification, cdr.mfr_bsr_id2 FROM tbl_CDR_Distributors cdr LEFT OUTER JOIN tbl_CDR_Classifications c ON (cdr.classificationid = c.classificationID) WHERE cdr.cdr_recordId = AND cdr.ownerid = AND cdr.fsl_tablecode = ---> UPDATE tbl_CDR_Distributors SET mfr_bsr_id = , utcTimeStamp = getDate(), utcSyncTime = null WHERE cdr_recordId = AND ownerid = AND fsl_tablecode = UPDATE tbl_CDR_Distributors SET mfr_bsr_id2 = WHERE cdr_recordId = AND ownerid = AND fsl_tablecode = UPDATE tbl_CDR_Distributors SET cdr_dstname = , cdr_dstaddress1 = , cdr_dstaddress2 = , cdr_dstcity = , cdr_dststate = , cdr_dstzip = , cdr_dstcountryID = , cdr_dstcompanytype = , cdr_dstPhone = , cdr_dstFax = , useSysFields = , cdr_dstcode = , comments = , cdr_territoryid = , mfr_bsr_id = 0 , setMethod = 3 , mfr_bsr_id = , setMethod = 5 , mfr_bsr_id2 = 0 , setMethod = 3 , mfr_bsr_id2 = , setMethod2 = 5 , setMethod = 1 , classificationId = , primaryContactId = , cdr_priority = , utcTimeStamp = getDate() , utcSyncTime = null WHERE OwnerID = AND FSL_TableCode = AND cdr_recordid = delete from tbl_ORG_AttributeLinks where mstr_attrId = and mstr_attrTypeId = ( select attrTypeId from tbl_ORG_attributeTypes where uniqueID = 'cdrRecordID' and attrType = 'Distributor' and FSL_TableCode = 'CDR' ) and child_attrTypeId = ( select attrTypeId from tbl_ORG_attributeTypes where uniqueID = 'FSPro_UserID' and attrType = 'FSPro Members' and FSL_TableCode = 'FSPM' ) insert into tbl_ORG_AttributeLinks (mstr_attrTypeID, mstr_attrID, child_attrTypeId, child_attrID) VALUES (63, , 34, ) 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