Be good to see what you mean by grouping. Show some results. FWIW, this is why testing is a good way to get set up for queries: https://www.sqlservercentral.com/articles/using-tsqlt-tests-to-practice-queries

That's the view of someone that sees these systems serving a few humans. These days systems serve other systems, humans around the world, and they can be live 24x7 for...

I've run into people that were sure you couldn't index unless this was persisted.

Fair point, and I'll reword.

This does change some parameterization stuff, but I think it prevents simple mode, which I'm not sure would be used here. Not sure, and haven't dug into this as other...

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.