SELECT DISTINCT offer_id_new ,Date1 FROM [PCGRecruitingDatabaseUpsize].[dbo].[ExtendOffer]
offer_id_new Date 819 2009-05-08 00:00:00.000 864 NULL 864 2010-08-08 00:00:00.000 866 NULL
SELECT offer_id_new ,max(Date1) FROM [PCGRecruitingDatabaseUpsize].[dbo].[ExtendOffer] GROUP BY offer_id_new
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)