Mark Cowne
One Orange Chip
Points: 26986
More actions
February 25, 2009 at 9:35 am
#950101
select PK
from mytable
where Event='Sold'
group by PK
having datediff(minute,min(Eventime),max(Eventime))>10
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
Marcus Farrugia
SSCarpal Tunnel
Points: 4718
February 25, 2009 at 12:06 pm
#950199
Thanks Mark, that's what i was looking for...
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply