SQL Select all rows that matching multiple condition in one column, Sql Server

Language: Layout:

create function [dbo].[delimitedsplit8K] (
      @pstring varchar(8000)
    , @pdelimiter char(1)
  )
returns table with schemabinding as
 return
  with e1(N) as (
    select 1 union all select 1 union all select 1 union all 
    select 1 union all select 1 union all select 1 union all 
    select 1 union all select 1 union all select 1 union all select 1
  )
  , e2(N) as (select 1 from e1 a, e1 b)
  , e4(N) as (select 1 from e2 a, e2 b)
  , ctetally(N) as (
    select top (isnull(datalength(@pstring),0)) 
      row_number() over (order by (select null)) from e4
  )
  , ctestart(N1) as (
    select 1 union all
    select t.N+1 from ctetally t where substring(@pstring,t.N,1) = @pdelimiter
  )
  , ctelen(N1,L1) as (
    select s.N1,
      isnull(nullif(charindex(@pdelimiter,@pstring,s.N1),0)-s.N1,8000)
    from ctestart s
  )
 select itemnumber = row_number() over(order by l.N1)
      , item       = substring(@pstring, l.N1, l.L1)
   from ctelen l
;
go

create table t (ID int,RecordNote varchar(32));
insert into t values 
 (1,'1:15&2:30&3:40')
,(2,'2:50&1:40&3:50')
,(3,'2:60&1:30&4:50')
,(4,'3:50&1:40&2:60')
,(5,'7:50&2:40&3:60');

create table p (patternId int, Pattern varchar(32));
insert into p values  (1,'3:50'),(2,'2:60');

;with cte as (
  select 
      t.Id
    , RecordNoteMatches = count(*)
  from t
    cross apply dbo.delimitedsplit8K(t.RecordNote,'&') s
    inner join p 
      on p.Pattern = s.Item
  group by t.Id
)
select *
from cte
where RecordNoteMatches = (select count(*) from p);

View schema
Execution time: 0,05 sec, rows selected: 1, rows affected: 7, absolute service time: 0,17 sec