Not really helpful.

If you delete data from a table would sp_clean_db_free_space satisfy a requirement that the data could not be recovered by forensic tools.  I am starting to...

If you had the opportunity to establish the processes and infrastructure to accomplish CI/CD from the ground up in a new company, how would you start?<

Looks good, except for my OCD when it comes to formatting.<

Really need some info here.
<b

After this:
when 'text' then 'cast([' + column_name + '] as varchar(max))'
add this:

-- Demonstrate math
declare @date date = '2016-03-31';
select @date CurrentDate, DATEADD(month, -1, @date) ReportDate, ReportYear = YEAR(DATEADD(month, -1, @date)), ReportMonth = Month(DATEADD(month, -1, @date));

-- Here is...

Just a quick question, If generating the report in January 2017 are you looking for just data in December 2016 or do you want December 2016 and in January 2017...

Amazing, the answer to the problem was right there in the error message.  But of course people are no longer willing to do any troubleshooting before asking for help.

Try the following for your trigger:

create trigger dbo.UpdateBatchNum on dbo.test after insert
as
begin
with BaseData as (
select
  project_id,
  service_id,
  BaseBatchId...