In T-SQL, I use this query to get the Partition Schema Number. I'm partitioning on a date column in the partition table.

SELECT

$partition.OrderDetailDatePartitionFunction(o.<date column>)

...

The first thing I would recommend is to change from caching the 70+ table on startup to only read the table data in as need – just-in-time (when the user...

I like the script; I had to make a small exchange to get it to work correctly. In the subquery where the temp table #tmpjoins is generated, I had...