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...

I'd go with Access.

Haven't seen anything on that. It's not on the @(local variable) page that I see.

Then again, I don't think it's a good idea. Just an interesting question

Not sure where sysname comes in here with "all variables", but am I missing something?