I have a table with name and dates in a table. For each name I need to find the first and last date for which the name appears in the table. I dont want to run any loops but for some reason can't warp my head around the query. I'll be storing the data in a temp table so if it's two queries and one as an update etc. thats fine. I just want to avoid the performance hit of a loop or cursor.
Name, First Date, Last Date