Posted by markc600 on 02/07/06 15:17

Some DDL and sample data would be useful. Here's an untested
shot in the dark...


CREATE TABLE THREADLIFECYCLE (unique_id INT,
start_time DATETIME NOT NULL,
end_time DATETIME)

CREATE TABLE MONITORRESULTS(unique_id INT,
time_of_measurement DATETIME NOT NULL,
value DECIMAL(10,2))


SELECT t.unique_id AS ThreadID,AVG(m.value) AS AverageValue
FROM MONITORRESULTS m
INNER JOIN THREADLIFECYCLE t ON m.time_of_measurement BETWEEN
t.start_time and t.end_time
GROUP BY t.unique_id

• Next in forum: Re: Views vs Stored Procedures, whats the difference?
• Prev in forum: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Re: one for the SQL experts - dare I say TRICKY SQL!

[Reply to this message]