Thanks to all who have responded with their ideas. I've been away for a couple of days & will be coding my solution this coming week.

Jeff, I have worked through the examples in the link you provided - excellent stuff, thank you.

I have a 'RoomType' table which I can use as my base table - just need to create a RoomTypeIntervals function to facilitate the CROSS APPLY & see how it performs when compared with the other suggestions.