Select start date and end date form records with subsequent date field in SQL Server 2008 R2 -

i have table in sql server 2008 r2 called reservelog. existing table stores reserve date of each room in complex.

it this:

roomnumber reservedate ---------------------- 1          2017-07-01 1          2017-07-02  1          2017-07-03 1          2017-07-06 1          2017-07-07 1          2017-07-08 2          2017-01-02 2          2017-01-03 2          2017-01-04 2          2017-01-09 2          2017-01-10 

i want query table following result:

roomnumber reservestartdate reserveenddate ------------------------------------------ 1            2017-07-01       2017-07-03 1            2017-07-06       2017-07-08 2            2017-07-02       2017-07-04 2            2017-07-09       2017-07-10 

is possible? can't make mind how it. appreciated in advance

create table #reservs ( roomnumber int, reservedate date )   insert #reservs values (1,          '2017-07-01'); insert #reservs values (1,          '2017-07-02'); insert #reservs values (1,          '2017-07-03'); insert #reservs values (1,          '2017-07-06'); insert #reservs values (1,          '2017-07-07'); insert #reservs values (1,          '2017-07-08'); insert #reservs values (2,          '2017-01-02'); insert #reservs values (2,          '2017-01-03'); insert #reservs values (2,          '2017-01-04'); insert #reservs values (2,          '2017-01-09'); insert #reservs values (2,          '2017-01-10');  select roomnumber, min(reservedate) mn, max(reservedate) mx ( select * , datediff(day, row_number() over(partition roomnumber order reservedate) ,reservedate) ind  #reservs ) group roomnumber, ind order 1, 2