I have worked with a few data scientists and none of them can do DBA work. The two areas are so distinctly different. Every data scientist I have worked with...

The good/bad news is all that I can find in any event logs is "The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s)." There is nothing...

I will definitely be planing upgrade. That will be fun seeing as it is in a vendor app and we have no test bed for changes. So fun dealing with...

The instance has had no patching so only the installed version without any patches.

And yes I am concerned.

Have a look a coalesce and see if it meets your needs MS coalesce article

I've worked with a lot of very good database people that were pre courses (started our careers in the early 80's) so all self taught. They would definitely have some...

Is it that you are trying to join this result set with another table?

Thanks Luiz and Drew for puting me straight, much appreciated.

Try running with the variable dates in dd-mon=ccyy format to help with debugging, ie '01 jan 1900

Have a look at the script here

http://www.sqlservercentral.com/scripts/IsNumber/70211/

Please read some of the article on this site about cursors, The discussions are fantastic and if you are thinking of working in the DB world, and I highly...

OK Fair call. So make sure MMM is equal to the abbreviation for the language installed, but it works regardless of the dateformat set.

My favorite date format for hard coded dates is dd mmm yyyy, so 15 apr 2015. I can't see any valid date format set on the server or db...

check for duplicate values in the table you are joining to. The dups will be on the joining field.

have a look at the case statement and use it in your select query. It will have a performance hit. Have you als othought of creting a lookup...