with fields as ( 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_OPR_Fields f with (nolock) where ownerId = and ownerType = ) select * from fields where category in ( ) update tbl_OPR_FieldValues set data = where partnerId = and partnerType = 'OPR' and fieldId = and valueIndex = 1 insert into tbl_OPR_FieldValues ( fieldId, partnerId, partnerType, data, valueIndex ) values ( , , 'OPR', , 1 ) delete from tbl_OPR_FieldValues where partnerId = and partnerType = 'OPR' and fieldId =