Kevin Wilkie breaks out the abacus:
Today, I was working with SQL Server to get row counts from several tables so I thought I’d be smart and work with some functions in SQL Server to make it smarter / easier.
Now, if I am truly only getting “straight” row counts from these tables, I would be able to create a query like the below that would provide the answers with no problem:
Read on for the normal approach, as well as a more complicated approach made necessary due to some business logic requirements.