My own horrible solution (which i think is something along the lines of what Japie Botma had in mind)

SELECT * INTO #TempWork FROM (
SELECT 'RCX_M01_SMD 1.0.6'AS AppVersion...

From the Microsoft docs link.

Dates can't be specified, so the date part of the datetime value isn't allowed. time_to_execute is formatted as hh:mm[[:ss].mss] and can optionally include the date of 1900-01-01.

Now I just find...

Which would be further proof that its an execution error and not syntax.

Your example is  "right" its just missing details. So something like

declare @prod table (id integer primary key, col1 varchar(32))
insert into @prod (id, col1) values (1, 'a'), (2,...

Look at the Lag function. That should probably work.

https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-2017

Problem with automation is that it also causes people to be sloppy, as in "the system will fix it / alert me".

I'm guessing you wrote that article in a program...

Even just knowing which column, would be a huge help.

I use the same solution for both when using an SSMS on my local computer as well as when using RDP. Use a horrible background color (red works well). That...