SQL Server查询以合并日期

I am trying to create a key based on an id plus a code plus a start date which spans a range of dates and consolidates id + code until another id + code comes along. Here is the data:I am trying to create a key based on an id plus