Thanks for tip, Jeff.

OK, here are 2 additional (and hopefully lest costly) queries to the get the days for a specific month.

I don't have any experience with the SQL...

Suggest that master dates table is best.

But if it's not available, here's a query that will give you the dates for a given year and month.

Still working on how to...

Are the inventory systems on the same server?

No - different servers, different environments

system A is JDE on an AS400

system B is oracle

Are the inventory systems both in SQL Server?

Neither

Have...