I don't see any need on doing a dynamic pivot in here. Your balanceflowtype column has limited values available, so it would be simpler to just code them. The pivot...

This is a way of doing it. It would be great if you could avoid this problem and get the unpivoted data to begin with, but that's something that might...

Here's a code that will list 200 years starting on 1900 and group them by calendar variation. You can have 14 possible calendars, 2 for each day of the week...

I would seriously question the need for this user to update data directly in production. If this user already caused an issue by deleting, I would expect the same thing...

I used to have Erland Sommarskog's beta_lockinfo utility. You could give it a try.
http://www.sommarskog.se/sqlutil/beta_lockinfo.html

This is another way of doing it.

WHERE [YourDateField] >= DATEADD( YY, DATEDIFF( YY, 0, DATEADD( mm, -1, GETDATE())), 0)


I'm not sure what the problem is, but you're certainly over complicating the conditions. This is a simplified version of your original code.

CASE
  WHEN [Col1] = '0'...