Hadn't seen that. I think the idea is that if you are using data as part of business to make money and storing in this SQL Server instance, you need...

But it's easy enough to clean up.  Just REPLACE(REPLACE(@sql, '1=1 AND ', ''), 'WHERE 1=1', '').  So if there are additional conditions, you remove the 1 = 1 and...

FWIW, I'd try to stick with one table, and use flags in other columns for items like holidays, workday, etc. I'd make this more like a dimension table in a...

This statement wasn't spurred on by the fact that SSMS 18.3.1 now tells you the complete time as a datetimeoffset(7) in the Messages Pane was it, Steve? Or just...

This is likely built dynamically, so the 1=1 provides a basis for the query.

You should not assume, guess, or expect other permissions.

A calendar table is key and Bobs solution works well to build one

SP2: https://www.microsoft.com/en-us/download/details.aspx?id=30437

Install SP2, then take a backup. Of course, test this to be sure SP2 doesn't break your app.

Then use the backup to restore on a new SQL 2014...

I've had an argument with my ex partner in the past, she claimed that women were discriminated against in the software world.

the truth is that I don't care if...

indeed

I assume you mean where. It's here (added in article as well): https://www.brentozar.com/archive/2017/03/databaserestore-open-source-database-restore-stored-procedure/

No hints to say anything but. As ZZMartin noted, you have a couple options.

Also, what was added and removed? These are columns, not fields, just to be sure we understand each other.

Perhaps you can better explain with some code what happened?

another vote for DBAtools.

Our warehouse is in the cloud, but really in an IaaS VM that runs a warehouse database.

ML? It's hard, and as Jeff mentioned, often T-SQL finds similar results that are...