I text my hotel room number and parking spaces to myself. Sometimes I forget where things are on different trips.

I'm not sure what this function is useful for, but I'm sure someone found a use. The best use so far is splitting IP addresses.

Quite the game last night for Henry. Watching him push people around was fun. Otherwise, not much of a contest.

cheers

head() gives you data, but not types.

Please don't post a question here. If there isn't a forum, pick a forum that's close and start a new thread. Don't hijack others.

I've added an ADF forum...

Calendar Table - http://www.sqlservercentral.com/articles/calendar/145206/
That will help you get this done. Depending on your locale, this might need modifications.

What version of SQL Server are you using?

I'd use the STRING_SPLIT() here, which is efficient for use. If you need to put this back into the column, you'll need to use string concatenation to get the result

I'll say that most of these books are 90% the same. The authors tend to follow what others do and so they get formulaic. I'd get a sample and read...

This, Dba-StartSQLJob, will help
https://docs.dbatools.io/#Start-DbaAgentJob

I'd add a PoSh step and use that to call a SQL Agent job on another server. That way I could actually see the execution metrics on both sides, with...