SQL server -T-SQL questions and examples.
Lessons once learned and now recorded.
SQL – Count combinations of values in several columns
You have a large table (in my case it has 8,697,647 records) with an Asset Number and a Business Unit, and you would like to know if any asset has record with multiple Business Units. You can count records of unique Asset/BU combinations, but this is not what you want: […]