Home Forums SQL Server 2008 T-SQL (SS2K8) Room occupancy per day given a date range RE: Room occupancy per day given a date range
dplaut 49149
SSC Eights!
Points: 820
More actions
October 23, 2012 at 8:55 am
#1551956
The method with the table of dates runs four times faster. This based on repeated tests with 1.8 million rows in the source table and putting out 6.9 million rows in the result.