Another nice aspect of this approach would be if you made the stored procedure use a Temp Table and a Merge, while making the TimePeriods table a temporal table.  This...

For people dismissing the security aspects of stored procedures -vs- direct table access through an ORM....

What are you going to do when some semi-technically savvy user opens up a copy...

I'm a little confused as to why this approach is better than, say, just creating the stored procedures as non-temporary stored procedures?  (yes, even non-temporary stored procedures can access temp...

Next you'll be telling us to break out a copy of Enterprise Manager 🙂