Get lineString using spatial data between 2 datetime fields

created table 3 fields:

system_name, start_date (datetime),close_date(datetime).

start_date , close_date present downtime of several components same system_name. down time systema:

a|--------------------|b               c|------|d                   e|----------|f                                     g|--------|h

want string line a-f , g-h.

want string line using geogrhpyic index or spatial data dont understand how use parallel events system_name

if understand asking....

are thinking of (http://blogs.solidq.com/dsarka/post.aspx?id=150&title=interval+queries+in+sql+server+part+2) for purpose of interval processing? kind of interval processing datetime, you'd need encode datetime number of (hours or minutes or seconds or ?) since starting time. have @ other entries in blog series; might see way better.

cheers, bob

SQL Server > SQL Server Spatial

Lun