Counting Records - SQL Server 2000
I need to count rooms sold. The problem is that a room can be sold more than once for any given trip. How can I retrieve all records including one instance where the room has been sold multiple times on a given trip?
Inv. Trip Room
1 A50805 201
2 A50805 202
3 B60805 201
4 B60805 201
The query should return records 1, 2, 3.
Any help greatly appreciated!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!