Give it a try and see!  🙂  Yes it should work like:

select
  substring(@test, 4, charindex(N',OU=' collate Latin1_General_CS_AS, st.some_column, 4)-4) some_name
from
  some_table st;

• This reply was modified 5 years, 10 months ago by Steve Collins.

The safest way to do this imo is to look for the first occurrence of ',OU=' in a case-sensitive way.

declare @testnvarchar(max)=N'CN=Some Person,OU=Sales,OU=Some Company - SK,OU=Companies - Some...

Maybe successively cross apply with partial joins?  Something like:

with
matrix_1(month_nbr, x_group, [1], [2], [3]) as (
    select 1, 'grp a', 1, 1, 1
  ...

Yes, union all works well.  Or you could insert into @Temptable twice.  It's not clear whether the information in the inserted 'Invoice' should contain all of "same informations (ID,DKey,SKey)..." because...

The whole retry loop could be removed in my opinion.  This is a basic upsert.  The variables used for flow of control are deterministic so the retry is not really...

• This reply was modified 5 years, 10 months ago by Steve Collins.

with
hotel_cte(customer_id, type_of_event, event_dt) as (
select 1, 'check in', '2019-12-30'
union all
select 1, 'check out', '2020-01-14'
union all
select 2, 'check in', '2020-01-14'
union all
select 2, 'check out', '2020-01-22'
union all
select 3, 'check...

Final answer, shamelessly borrowing from Jonathan, still without CROSS APPLY.  Also, Jonathan's answer with sample data cte included (copy/paste/run).

/* borrowed */
with
LifeCycleMaster_cte(Revision_ID, ZPartID, LastCheckDate) as (
select 12, 10,...

Well I was close.  Should've summarized from the beginning.  I thought about CROSS APPLY but it seems fussy when there's no TVF because there's still the old ways.  The DISTINCT...

with
LifeCycleMaster_cte(Revision_ID, ZPartID, LastCheckDate) as (
select 12, 10, '12/12/2015'
union all
select 15, 120, '12/01/2014'
union all
select 15, 130, '05/05/2016'
union all
select 20, 170, '09/03/2013'
union all
select 20, 200, '09/05/2016'
union all
select 20, 300,...

One way to simplify things could be to resolve the hierarchical adjacency between airports, countries, and areas using a table.  The ServicLevel case logic could also be replaced by a...

Currently there's no way to join rows from table t...

How is the data model originally populated?  The examples provided set IDENTITY_INSERT ON.  Are the examples representative of how inserts into the Child db tables occur in actual usage cases? ...

How does table t join to table t1?  Are the rows intended to be in sequential 1-to-1 correspondence?  If yes, why not create only 1 table instead of 2?

Is it required to read the file using ADF?  There are a few ways to do it with just Sql Server (and without ADF).   The Json could be read from...

Here's my attempt.  Because you're expecting a lot of rows from this query I wouldn't bother with outer applying top(1)'s.  Rather it might make sense to break the cte into...