It does seem like a weird inconsistency. You could try filing a bug against it, but it may fall into the "sometimes triggers are just weird" category and not get...

I can't claim to have invented it, I'm fairly sure I picked it up from this site somewhere. It may even be an article already...

You can use the installer to generate a configuration file, then subsequently use that to automate the process of installation. https://docs.microsoft.com/en-gb/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-2017

You don't need all the temp tables and,unless you don't mind the data being wrong, you really don't need the nolock hint:

Insert Into CreditCard(CreditCardID,ActivityId,CardDetails,TransactionDateTime,TradingId)
Select 
 A.CreditCardID,

I too would tend to use the CASE variant, but it's worth noting that:

August 21, 2018 at 8:35 pm

#2002784

One thing to bear in mind if your boss isn't a SQL guy, is that the terminology around SQL Backups is a little different than the usual backup terms and...