Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to determine sequence for date events linked to same id
So the end result I'm looking to get would be something like this ( and the starting point is the same but without the first 2 columns, which I'm trying to derive): the columns below are: new event id; sequence; pt id; event start date; event end date event id 001 1 2244 01/09/2011 10/09/2011...- newbie92
- Post #4
- Forum: Microsoft SQL Server: Programming
-
How to determine sequence for date events linked to same id
Hi everyone I have a table with thousands of records listing pt id, start date, end date, event id where records were incorrectly coded with different event ids for events that were actually one continuous event and that should therefore have an aggregate event id. I need to group them by pt...- newbie92
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
