Like this?
https://stackoverflow.com/questions/420741/getting-list-of-tables-and-fields-in-each-in-a-database

 I suppose you could easily find non-matching tables by grouping on column name and getting COUNT = 1?

SQLCompare by RedGate does that, I...

Figured out a small piece of this that was still wrong. I needed to change so that I get the MAX level for each course. Then it makes sense.  (Because...

Here's an example I shamelessly  copied out of Itzik Ben-Gan's T-SQL Querying book:
SELECT custID, orderID, orderDate, val,
    SUM(val) OVER (PARTITION BY custid, YEAR(orderDate)
                    ORDER BY orderDate
                    RANGE...

(sorry for interrupting)
It's possible to do a running total (if you're using 2012 or later...)
See this: https://docs.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-2017

Look for the Cumulative Total.
PARTITION OVER is analogous to...

What if you do something like copy the column names from the first sheet, then loop through the rest of the sheets, and insert a new row above the existing...

Oh wow... MUCH more readable!

I think I get it... Here's a tiny subset of the columns in the Catalog table:
SELECT ItemID
    , c.[Name] as ReportName
FROM dbo.Catalog c
WHERE c.Type =...

What if you insert the data in batches? That would make the transactions smaller, and maybe faster.

the same row?
INSERT INTO MyTable(col1, col2, col3, col4) VALUES (@param1, @param2, @param3, @param4);

What's the big deal? Use DATEDIFF() to figure out how old a bill (or whatever) is, and then use CASE to group into bins.
If you do this in SSRS,...

You realize that you have to rebuild your indexes when you do that, right? Only use SHRINKDB if you need to get back space you're not going to use for...

Got consumable data? (CREATE TABLE/INSERT scripts)??? Surely you've figured out how to do that by now. Unless you want just guesses instead of tested code.

Can you post your CREATE TABLE and INSERT scripts so we have a little bit of sample data? Invoices and . InvoiceLineItem structures are pretty standard. If you post the...