Dave - Fair point, but there's a bit of (dull) background as to why I'm looking down other paths...

As it happens we do it in SSRS at the moment, but to keep my post from confusing everyone I didn't mention that once I've got the data returned in column-per-date format I then want to do some calculations, such as room cost, total room cost for all people each night etc.

If I use an SSRS matrix/tablix then I really struggle to then do the calculations because there's no handle to grab on to for each date if the columns are generated at runtime. I would set fixed columns for each date, but need to produce this report quite regularly, for different date ranges each time!

I still want to use SSRS to deliver the results to the user at the end. It would just help if the query behind that report already had a column for each date.