0

Please login or register to vote for this query.

(click on this box to dismiss)

Your h-index is the highest number n, such that you have at least n questions/answers, all of which have at least n score.

Q&A for professional and enthusiast programmers

DECLARE @hindex INT 
SET @hindex = 0

WHILE (SELECT COUNT(*) FROM Posts WHERE OwnerUserId = ##UserId## AND Score >= @hindex) > @hindex
BEGIN
    set @hindex = @hindex + 1
END

SELECT @hindex

fork query

edited apr 5 12 kevincathcart

created aug 24 11 jon.doe6534