We actually had this just yesterday. Someone deleted 100 records from our CRM, told us about it 30 minutes later. We did a point in time restore, but lost 30...

I think that's my problem. Instead of calendar_users, I have this nasty unpivot table.

I'll try manipulating your last query to go off the unpivot.

OK here is the big table

OK here is the code.

And to GSquared, I actually do have a Calendar table, but it doesn't have the enabled/disabled switch in it. See below:

Create the date table

SET ANSI_NULLS...

The problem is I don't have permission to change the structure of this table.