I dont have query analyzer handy at the moment so did not test the working of the

following query yet. you can try this in the

meanwhile.

select distinct groupid,TaskId,Time

from Tasks...