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
Comments
Post a Comment