Retrieve element attribute recorded values using Simplified Asset Database E-R Model

SELECT eh.Path + eh.Name + ea.Path + ea.Name Path, r.*
FROM NuGreen.Asset.ElementHierarchy eh
INNER JOIN NuGreen.Asset.ElementAttribute ea ON ea.ElementID = eh.ElementID
INNER JOIN NuGreen.Data.Archive r ON r.ElementAttributeID = ea.ID
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'
AND eh.Name LIKE N'B-%'
AND ea.Name LIKE N'%Flow'
AND r.Time BETWEEN N'01-Aug-2011' AND N'02-Aug-2011'
OPTION (FORCE ORDER)