As per what I understood you're trying to identify IndID that has latest UpdateDate faling within last 5 years. if that being case, you can use something like
SELECT IndID
FROM (SELECT IndID,MAX(UpdateDate) AS MaxUpdate
FROM view
GROUP BY IndID
)t
WHERE MaxUpdate >=DATEADD(yy,DATEDIFF(yy,0,GETDATE())-5,0)
AND MaxUpdate <DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)
the view would be like
SELECT IndID,UpdateDate
FROM table1
UNION ALL
SELECT IndID,UpdateDate
FROM table2
....
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
IndID Last Updated in Several Tables
Posted - 02/11/2013 : 16:12:37
