This really isn't clear - how is the offset being used?  It doesn't seem to be considered in the calculation - it seems that you want to get the previous...

And yet - ISNULL, COALESCE, NULLIF are all converted to a CASE expression (not statement) under the covers so they all should not be included by your argument.

Your argument against...

How are you going to present a row with 365/366 columns...

Sorry, hit enter. It would be good to understand if you want 1 or 2 fields in the result. The way you write this, I'm not sure. I think...

CASE, ISNULL and COALESCE are all an integral part of SQL Server and follow its general syntax.  It's because IIF is so unlike other other functions and expressions in...

There are uses for IIF - just the same as CHOOSE and other shortcut features that...

Here is an alternative that doesn't require the use of CASE or IIF:

Declare @testTable Table (var1Title varchar(30), var1Topic varchar(30), var1Name varchar(30));
 Insert Into @testTable (var1Title, var1Topic, var1Name)
...

--===== Create and populate the test table
   DROP TABLE IF EXISTS #TestTable;
 CREATE TABLE #TestTable 
        (begin_time...

Look at using OUTPUT instead of a SELECT/INSERT method (https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver15)

If you keep this line 'SET TRANSACTION...

There is a schema change report - it might contain that information if the trace data is still available.  I would check there first - right-click on the database in...

If tempdb is growing every time you run this package - that indicates another process somewhere that is shrinking the files.  You should not be shrinking the files...reset the size...

If you remove a database from the AG - and then that database back before a new transaction log backup has been run, then SQL Server can synchronize that database...

I'm not a fan of PowerShell. I use it very infrequently, and as a...

What is the code in D:\MyFile.sql?

The 'Select' needs to select one of the available columns in $recordData - which will be defined by the query in D:\MyFile.sql.  If you query...