set @topRank=(SELECT MAX(RANK) FROMSELECT (CAST(ftt.RANK as DECIMAL)/@topRank) as matchpercent, --Round this titles.titleFROM TitlesFREETEXTTABLE(titles, no
;foreach (var ft in failureType) var fttfailureTypeTranslations.FirstOrDefault(i => i.failure_type_id == ft.failure_id && i.language.ToLower().Equals(lang));
if (ftt_descriptionTr = ftt.des