Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT a.tDate , convert(time,a.tTime) Time , Object1 = MAX(ISNULL( b.Object_1 * c.Duration / 60.0, 0 )) , Object2 = MAX(ISNULL( b.Object_2 * c.Duration / 60.0, 0 )) , Object3 = MAX(ISNULL( b.Object_3 * c.Duration / 60.0, 0 )) FROM tblTimes a JOIN tblObjects b ON a.TimeID = b.TimeID JOIN tblDurations c ON b.DurationID = c.DurationID GROUP BY a.tDate,convert(time,a.tTime)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.