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...

I was coding a solution for this on the other Sql Srv forum where you posted -- and then deleted --  this q.

Here is my answer: the ISNULL(...) stuff is...

I think you need to add the file "key" -- to identity the unique file being loaded -- to the data file to distinguish between rows.  That doesn't violate data...

Yes, this is the exact usage case for a FULL OUTER JOIN:

SELECT 
    COALESCE(t1.PhoneNbr, t2.PhoneNbr) AS PhoneNbr,
    COALESCE(t1.Interval, t2.Interval) AS Interval,
...

Yes, the DIFF will.  You can do a DIFF any number of days after a FULL and it should work fine.  If a lot has changed in the db, the...

Agreed overall.  I will say, I wouldn't object to providing the user with a view ("table" perhaps to them) that had 600 columns, if that is what they needed.  But...

If you're directly designing "tables", you don't have a good design process and you are not doing proper normalization.  That's because normalization is a logical process, not a physical one.

What...

To save space, ENCRYPT the body (and other very long columns).  This process is rather slow, but it typically does save a lot of space.

And, using triggers, you...

What a mess!

(1) as above

(2) yes; you might consider breaking those links until after you're cleaned this up.  Then again, that has its own issues as well.  What a mess!

And...