Posted by markc600 on 04/20/07 13:49

If you are using SQL Server 2005, you can do this

with cte(location_id,date_created,grp)
as (
select location_id,
date_created,
rank() over(partition by location_id order by date_created)
- rank() over(order by date_created)
from mytable)
select location_id,
max(date_created) as date_created
from cte
group by location_id,grp
order by max(date_created)

• Next in forum: Re: Interesting SQL problem : How to track movement history
• Prev in forum: Interesting SQL problem : How to track movement history
• Thread view: Re: Interesting SQL problem : How to track movement history

[Reply to this message]