Thank you ALL for your responses.

One question though. Won't this subquery

SELECT forum_id, max(thread_id) as max_thread_id, MAX(postdate) as last_postdate FROM #Threads GROUP By forum_id

return the highest thread_id for...