Egads, I knew I should have put more in my post!  Here is a full script:

@if exist __Test.txt del __Test.txt

sqlcmd -S MYSERVER -d MYDB -E -i pPoodle.sql >> __Test.txt

sqlcmd -S MYSERVER -d MYDB -E...

While I feel the ID-based joins are a little over-the-top, I have used date tables in two locations for years.  One, on the OLAP side, to reduce processing time in...

I had a thought I wanted to put out for general response.  While I certainly encapsulate my code into stored procedures whenever possible, I also keep as much "business logic"...