Good catch. Updated question

Your last sentence doesn't quite make sense. You can just let the output come back and use redirects >>, to put the data into a file.

SQL Server doesn't track much by default. There is data in the DMVs, but all monitoring tools do is read this, aggregate, store, and manage data retention. If you don't...

Looks I'm gonna lose. Forgot to check the lineup, and now need a new kicker. Not that that mattered.

SQL Sat Memphis this weekend as well. Lot of fun and enjoyed my trip.

https://www.sqlsaturday.com/870/Sessions/Schedule.aspx

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