Alternative solution using patindex
😎

IF OBJECT_ID(N'tempdb..#temptbl') IS NOT NULL DROP TABLE #temptbl;

create table #temptbl
(
c1 varchar(100)
)

insert into #temptbl

In my opinion, the most important part is to have a workstation box at the other end to connect to which has all the tools needed and then vpn /...

This might help you, restarts the count on a new year. Subject X from year n-1 will be counted again on year n.
😎

IF OBJECT_ID(N'tempdb..#Test') IS...

What exactly are you installing? Please provide all the version information, OS type, build numbers etc.
😎

Am I missing something here, cannot see any question?
😎

Not entirely certain what you are after but here is an example that 

1. Finds the first visit for each ID
2. Aggregates the number of visits to Year-Month
3. Does a running total for...

Pitching in some more, normally I use Ola Hallengren's Maintenance Solutions for running the integrity checks and use the option of logging to table. This then allows me...

Quick thought, if it runs clean with no errors then there is an entry in the sql server log, if there is a corruption, look for (and archive) the SQLDUMPnnnn.txt file...