Is this a production server?  
What you are finding out is why doing in-place upgrades is less than desirable.  

Honestly, without a lot of trial and error, I would...

We've been interviewing candidates for a BI/Reporting position.  Same things, 30 years of senior level experience and they can't get the system date and time. 

But, the astounding thing...

What have you tried?  Can you post that code?

A few questions.
Will there always be only 3 scores for a course for a student? In other words, there...

It also looks like you are confusing a WHERE clause in SQL with an IF statement in a programming. 
These are fundamentally different structures.  Far too many programmers think that...

It also truncates the string if there are double spaces. 

I used:
'This Is a Test of this function'
it returned
'This Is A Test'

There should have been a 5th option.  
Look at the plaque on the wall with the changeable numbers that the kids keep in sync.

Assuming a 2 node, active/passive cluster, you would need the following:
1. Server 1 actual name and IP address
2. Server 2 actual name and IP address
3. Virtual cluster name and...

Did you actually read Books Online?

https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/deterministic-and-nondeterministic-functions

This may work.
DATETIMEFROMPARTS (DATEPART(year, c.Calldate), DATEPART(month, c.Calldate), DATEPART(day, c.Calldate), DATEPART(hour, c.calltime), DATEPART(minute, c.calltime), DATEPART(second, c.calltime), 0)