My highest quality answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

An attempt to locate my "best" answers. Very short answers sometimes gain a lot of upvotes, but it can be argued if these are the best answers. This query multiplies body length with score in order to give longer (and presumably more informative) answers more weight.

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

-- My highest quality answers
-- An attempt to locate my "best" answers. Very short answers sometimes gain a lot of upvotes, but it can be argued if these are the best answers. This query multiplies body length with score in order to give longer (and presumably more informative) answers more weight.

SELECT TOP 100
  p.Id,
  p.Id as [Post Link],
  (p.Score * LEN(p.Body)) as [Weighted Score],
  LEN(p.Body) as [Post Length],
  p.Score
FROM Posts p
WHERE
  p.OwnerUserId = ##UserId## and
  p.posttypeid = 2
ORDER BY
  [Weighted Score] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results