Snapshot query for end of year

scabral79  you can achieve this by using a combination of common table expressions (CTEs) and the ROW_NUMBER() window function to identify the latest row for each year.  

WITH YearlyData AS (
    SELECT
        LocationId,
        EquipmentNum,
        RecNum,
        VersionBeginDt,
        ROW_NUMBER() OVER (PARTITION BY LocationId, EquipmentNum, RecNum, YEAR(VersionBeginDt) ORDER BY VersionBeginDt DESC) AS RowNum
    FROM
        #temp
    WHERE
        YEAR(VersionBeginDt) BETWEEN 2018 AND 2023
)
SELECT
    LocationId,
    EquipmentNum,
    RecNum,
    VersionBeginDt
FROM
    YearlyData
WHERE
    RowNum = 1
ORDER BY
    LocationId,
    EquipmentNum,
    RecNum,
    VersionBeginDt;

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
Note: