Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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)
|Inserts running very slow from Application to Database in SQL Server 2012||5||81|
|t-sql look for records in two tables||2||19|
|Cannot install / add SQL database when installing MyCalls software||22||40|
|sql calculate averages||18||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!