---> insert into tbl_CDR_ContactDetails ( ownerId, ownerType, fspro_userid ) values ( , , ) insert into tbl_CRM_PartnerURLs (ownerId, ownerType, partnerId, partnerType, urlType, urlValue) values ( , , , 'CDR', , ) 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 lastUpdated = , #_cdrFieldName# = , lastUpdatedBy = WHERE fsl_TableCode = AND ownerId = AND cdr_recordId = 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 = switch(fieldName){ case "address": cdrField = "cdr_dstaddress1"; break; case "address2": cdrField = "cdr_dstaddress2"; break; case "city": cdrField = "cdr_dstcity"; break; case "companyName": cdrField = "cdr_dstname"; break; case "countryid": cdrField = "cdr_dstCountryId"; break; case "distributorId": cdrField = "cdr_recordId"; break; case "priority": cdrField = "cdr_priority"; break; case "state": cdrField = "cdr_dststate"; break; case "territoryId": cdrField = "cdr_territoryId"; break; case "phone": cdrField = "cdr_dstPhone"; break; case "zipcode": cdrField = "cdr_dstzip"; break; default: cdrField = fieldName; break; } return cdrField; select f.fieldId, rtrim( ltrim( f.name )) name, rtrim( ltrim( f.category )) category, rtrim( ltrim( f.label )) label, f.type, f.required, f.format, f.config, f.sortRank, f.maxLength from tbl_CDR_Fields f with (nolock) where f.ownerId = and f.ownerType = and f.category = and f.name = update tbl_CDR_FieldValues set data = where partnerId = and partnerType = 'CDR' and fieldId = and valueIndex = 1 insert into tbl_CDR_FieldValues ( fieldId, partnerId, partnerType, data, valueIndex ) values ( , , 'CDR', , 1 ) delete from tbl_CDR_FieldValues where partnerId = and partnerType = 'CDR' and fieldId =