0

Please login or register to vote for this query.

(click on this box to dismiss)

On avg how often are answers I give, accepted

Q&A for SharePoint enthusiasts

-- What is my accepted answer percentage rate
-- On avg how often are answers I give, accepted

SELECT
    Id,
    DisplayName,
    CreationDate,
    LastAccessDate,
    Reputation / NULLIF(
        DATEDIFF(day, CreationDate, LastAccessDate), 0
    ) AS ReputationRatio
FROM 
    USERS
WHERE DisplayName = 'u111'
ORDER BY 
    ReputationRatio DESC;

fork query

edited oct 22 anonymous

created may 25 10 sam.saffron