Yes, the files are transferred, that's not my main concern.

It seems so crazy to me that I can generate all the info I need in just a single, very...

Steve,  I wasn't talking about the expansive output.  I was talking about the test code generator.

Shifting gears, the OP provided no example of a left string having more than one...

I have a huge table with 3B of rows containing around 6 months of data running on Microsoft SQL server 2017 (RTM), which is partitioned day by day on...

Jason A. Long the "s3 string" characters which appear after the brackets do not appear in any of the OP's example rows.  Imo that's a made up requirement which...

I will stop now as it is obviously important for you to prove that tally is the only solution. Your tests are based on the fact that the function...

Yep.  Understood.  And, I agree... more core and ram isn't going to change the problem with compile times.  But, so far, no one has played with more than about 6...

I had been told by people in my agency that my new server was at least good as the old one. However, when the consultant compared the old server...

Hey there, Carsten.  I really appreciate that you have limited resources in Azure.  It's taking me a while (had to write some code...

This just sounds like the basic skill required for properly documenting any code but slightly extended.  The comments should explain the What and Why.  You can read the code for...

Enquiring minds want to know... where the hell did the OP go?

And, yeah... I'm a poet and don't know it. 😀

No, the plan for a procedures, functions, ... when then  execution cache is not big enough to hold all the plans - do you have a server that can...

That's really not helpful at all.

Wouldn't it be easier to take a snapshot of sys.dm_db_index_usage_stats from one day till the next and do a comparison?  The added benefit here is that it includes...

Hi,

Please refer below code snippet -

;WITH DateTable AS (
SELECT * FROM (VALUES
('2020-07-01',0,0),
('2020-07-02',0,0),
('2020-07-03',0,1),
('2020-07-04',1,0),
('2020-07-05',1,0),
('2020-07-06',0,0),
('2020-07-07',0,0),
('2020-07-08',0,0)
) AS t(DateValue,isWeekEnd,isHoliday)
),
TicketTable AS (
SELECT * FROM (VALUES
('Ticket1','2020-07-01','2020-07-06'),
('Ticket2','2020-07-07','2020-07-08'),
('Ticket3','2020-07-07',NULL)
) AS t(Ticket,CreateDate,ResolvedDate)
)
SELECT t.Ticket,t.CreateDate,t.ResolvedDate,
DATEDIFF(DAY,t.CreateDate,t.ResolvedDate) - SUM(d.isWeekEnd)-SUM(d.isHoliday)...

Yes, I was also thinking from a maintenance perspective dynamic would not be the best solution.  Today its 3 missing, it might be 5 in the future so adding...