select upper( rtrim( ltrim( f.category ))) category, upper( rtrim( ltrim( f.name ))) name, fv.data, f.type from tbl_#_flexDomain#_FieldValues fv with (nolock) inner join tbl_#_flexDomain#_Fields f with (nolock) on f.fieldId = fv.fieldId where f.ownerId = and f.ownerType = and fv.partnerId = and fv.partnerType = order by category, name