Gets all posts you have edited and
>Gets the difference in months, between when they were created and when they were last active.
>Gets the difference in months, between when they were created and when they were **last edited**.
This could help you figure how close you are to Excavator and Archeologist
Q&A for professional and enthusiast programmers
SELECT top 500
Id as [post_id]
DATEDIFF(month,LastActivityDate,GETDATE()) > 24
/* As always I'm doing this as a learning exercise and some of my findings
The column alias cannot be referenced in the select portion of the clause: