SELECT
TV.ThingyId,
TV.UpdateDtm,
OA.Property,
OA.IsApplied
FROM dbo.ThingyVersion AS TV
OUTER APPLY
(
SELECT TP.Property, TP.IsApplied
FROM dbo.ThingyProperty AS TP
JOIN
(
SELECT MAX(TP2.UpdateDtm) AS Expr1004
FROM dbo.ThingyProperty AS TP2
WHERE TP2.ThingyId = TV.ThingyId
AND TP2.UpdateDtm <= TV.UpdateDtm
) AS J
ON J.Expr1004 = TP.UpdateDtm
WHERE TP.ThingyId = TV.ThingyId
) AS OA