I've added some date calc ctes before the query to isolate the date calcs from the main query (also makes it much easier to test them standalone for assorted dates). ...

No problem.  I don't have a real problem with CROSS APPLY, other than the performance hit.  I personally am not a big fan of UNPIVOT, I find the syntax kludgy...

You really don't need UNPIVOT or CROSS APPLY for this.  They do add some overhead.

SELECT
    Doc,
    SUM(CASE WHEN CHARINDEX('d', Op1+Op2+Op3+Op4) > 0 
        THEN 1 ELSE 0 END)...

I pointed out CHECKPOINT.

I have servers with hundreds of dbs.  If you just slam them down, the recovery...

You can add an EXEC AS.  Create a login that has only the specific authority it needs in the mgmt db to INSERT to the table; i.e., it doesn't need...

Agree completely, it should work, as long as the drive has the same letter and paths, just verify that the needed permissions are all back in place.

Scott - Thanks for the reply. So when you stop the Agent, what happens to the jobs that were supposed to run during the stoppage? That's mainly what...

If you stop the Agent, it will not go back into the past to run jobs when it is restarted.

Scott and as1981, thank you for taking the time to respond.

Scott's approach works well enough, though I do not wish to universally add an IsValid flag to our tables,...

If SQL service itself is going to be stopped, then you should definitely stop the Agent service first.

I'm not sure if the Agent would try to run missed jobs later...

You're using a proc not a function.  You should use a function.  If you'll post the proc code, we can help you rewrite it as a func.

For the proc, to...

The...

You could add a tinyint (or bit) indicator to the table row itself indicating whether that row has been reviewed already.  (Maybe tinyint so that there are bits for other...

Add this statement immediately before the statement:

if (@turnoid <> 0 or @turnoid is not null)

That will help you see what results you are getting in the code and whether or...