Maple07-598122 (1/25/2013)
I have a table keeps guest records in a hotel. For each guest I have check in date and check out date. If I want to know how many guests the hotel served on each day in December 2012, how should I write the query?Thanks
without only that much information ... a working answer is to say the least - difficult.
If you post your table definition, some sample data, someone will probably post the necessary tested T-SQL.
To assist those who desire to assist you, please read the first link in my signature block,
it gives examples of data required and contains the T-SQL code to allow you to do this rapidly and easily.