Not to mention "Y", "N", month names with no reference to a year and much more.

I definitely have an appreciation for the "old" days.  I used to be able to read the holes on a Hollerith card and tell you what it said. 😀

So, thanks...

Call it what you want, using a GUID to "represent the PK" or vice versa makes no sense to me.   Both columns are fixed width (unless you've done row or...

I really appreciate what you tried to do with the readily consumable data but it's broken.  The table creation is broken and the table to be inserted into is not...

To be honest and with the understanding that I have no real good grip on what your processes require, I see no serious merit in having both the IDENTITY column...

So, they came up with a workaround as below.

- Introduced a new column as BIGINT column. - Made the bigint column as NOT NULL IDENTITY(1,1) with clustered...

At home, apparently my call sign is "DINNER!" 😀

On the "hoping" thing, that was just a bit of "before I had enough coffee" conversation. 😀

On Zidar's approach, and like I said in my response, the method that he...

Heh... call the folks that are on the infrastructure team.  They'll know.

Steve... you not a mentor for me that that doesn't stop you from being a hero of mine.  You've kept this site going and inspired a whole world of mentors. ...

Well. I am pretty sure that it is not due to recompile because it recompiles every time anyway as an old-asp-concatenated sql statement. But also I went the MAXDOP...

I have found that's usually not the problem but...

@zidar-2,

Thanks for the feedback and the code.  It's always appreciated, especially when it's a slightly different take on things.

In...

Reducing MaxDop helped, actually. elapsed time reduced from seconds to milliseconds now. Pre-creating temp tables did not change metrics but i understand what you all said regarding that it...

In the tvf it seems possible to factor out a common table expression and the UNION ALL by adding +1 to the row goal and -1 to the...