Glad it's working and thanks for providing an explanation of what worked.

Is it just the three columns? You can use CASE to check for a meeting and calculate a time, then sum those up. If no meeting, return a 0 to...

Re: The editorial
It's interesting to ask us to perhaps behave or choose in ways that get along with or go along with the flow of wherever we are, but...

Have you looked at first_Value? You can partition this and get the first lead date for a code item.

You do lose some SQL 2014 features. New keywords don't work, as the purpose of compatibility mode is to allow older code that might have a keyword, such as the...

Are you unsure of how to do this?

insert target
select columns from source s
  inner join target t
 on s.date <> t.date

SQL Server doesn't track this activity outside of the default trace.

If you have nightly file system backups, maybe you have a record from the older trace or...

Good question. No idea. I assume they go back to...

What are defunct filegroups? I'm not sure what you're doing or what the set up is currently.

Variables can't be used as columns. You can use dynamic SQL as noted to get a different column returned.

A wrapper is a good idea, especially if you can get a version somehow and have the procedure automatically change things.

My $0.02, Microsoft is not removing numbered procedures....

This is what Filestream was created to do. If the images are > 1 MB, you get better performance with them as files in the file system rather than in...

I would open a case with MS here. I haven't seen anyone getting corruption with TDE because of enabling it, but there might be some bug. I would be worried...