Thank you,

Is this the one for CU8 thanks,

on this page  https://www.catalog.update.microsoft.com/Search.aspx?q=sql%20server%202019

on Steve's page:

Could you please explain what this part mean?

cross apply (values (charindex(',', string),

len(string))) st(cloc, lng)

also can the cross apply replace with inner join?

thanks

Thank you so much, that works.

But I need to understand this more, esp,  those functions and cross apply. Will come back with questions.

Thanks. The reason we want to do this is to update  firstname, middle and last name in a table with the displayname in active directory. but in active directory the...

Thanks, what does st(cloc, lng) mean?

I join with my table, but it says  'Incorrect syntax near 'st'.'

SELECT employeeID

,DisplayName

, lr.l fname, calc.lname, calc.m_init

FROM dbo.ADStaff a

cross apply (values (charindex(',', DisplayName,

len(DisplayName))) st(cloc, lng)

cross...

Thanks, Of course I can just back the log up, and do the full backup.

My question for this post is try to figure out what is the reason to do...

Another point:

Original code is in a table-valued function, then I use other table to join it.

For your code above, should I do same thing, put it in a table valued...

The result is just like above Steve posted.

Wow, that is so much faster. Thank you Steve. Now let me take a look to understand the code, is it the fnTally make it so much faster?

I will give it a try, so the fnTally is the one I can copy here? thanks

https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally

Thanks, what is the benefit to use a calendar table, all we need is to know the first day and end day, If we create a calendar table,  that has...

try to attach file again

I attache the schema of sample data scrambled for testing

why there are some many spam from this site recently that sent to my email?

The process failed intermittenly. For example on Monday It runs OK, on Tuesday it fails, on Thurday it runs OK again. Everytime it shows connection failure. Also at the same...