SELECT   *
FROM     blah
WHERE    DATEFROMPARTS (Year, Month, Day) = (SELECT MAX(DATEFROMPARTS (Year, Month, Day)) FROM blah);

;WITH CTE AS
(
    SELECT   Description, MaxDate = MAX(DATEFROMPARTS (Year, Month, Day))
    FROM     blah
    GROUP    BY Description
)
SELECT  *
FROM    blah B
        INNER JOIN CTE
           ON B.Description = CTE.Description
           AND DATEFROMPARTS (B.Year, B.Month, B.Day) = CTE.MaxDate;