2

Please login or register to vote for this query.

(click on this box to dismiss)

List N-rep users who haven't been seen in the last X to Y days

Q&A for professional mathematicians

-- Users missing in action
-- List N-rep users who haven't been seen in the last X to Y days

select Id as [User Link], Reputation, LastAccessDate, DATEDIFF (day,LastAccessDate,GETDATE()) [Last seen days]
from Users
where Reputation > ##SearchForRepGreaterThan:int##
and DATEDIFF (day,LastAccessDate,GETDATE()) between ##MinDaysSinceSeend:int## and ##MaxDaysSinceSeen:int##

fork query

created jan 12 11 Benjol