To find those that required a lot of work. :-) Or a copy/paste. :-(
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
-- The longest answers. -- To find those that required a lot of work. :-) -- Or a copy/paste. :-( SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User Link], LEN(Body) AS Length, LastActivityDate AS [Last Activity Date] FROM Posts WHERE PostTypeId = 2 ORDER BY Length DESC