Here's what I used

;with

groupeddates as

(

select uniquedate = [Date],

DateGroup = DATEADD(dd, - ROW_NUMBER() OVER (Partition by RoomId,RoomReservationStatusId ORDER BY RoomId, RoomReservationStatusId, ExtraBedCount, [Date]), [Date]),

RoomReservationStatusId, RoomId, ExtraBedCount

from Room_Booking

where ReservationId...

Thanks..

http://www.sqlservercentral.com/articles/T-SQL/71550 had exactly what I needed. I hadn't quite understood the "multiple objects" when I saw the post earlier..

Regards