Everything Windows – Windows Server – SQL Server – Windows 10, 8, 7, even XP
MS Office tricks – Registry secrets – Applications – Browsers
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: […]