0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT top 10
    Id AS [User Link], 
    LastAccessDate,
    dateadd(DAY, -30, GetDate()) as [End]
FROM
    Users
WHERE
    LastAccessDate < DateAdd(dd, -30, GetDate()) 
ORDER BY
    LastAccessDate Desc

fork query

edited apr 5 12

created apr 5 12 anonymous