Derive date from two (or more) existing dates - Sql Server
I have a situation in which I'm expected to derive end dates for a record from a single field for a variable amount of records...and if the record has no next record then the final record = '2099-12-31'
For instance this:
Needs to be coded to end up as this
Member Identify_Date End_Date
14 2011-01-01 2011-02-13
14 2011-02-14 2011-02-28
14 2011-03-01 2099-12-31
I've been working on this all day. Can't figure it out. Thanks so much for your help.