USE master
GO

WITH FilterTable(Namen,StartDate,StopDate,Price,Filterr)AS
(
  SELECT 'ABC','20201010','20201110',1000.00,''
   UNION ALL
  SELECT 'ABC','20201101','20201105',200.00,'XXX'
),
ActionsTable(NameN,DateAction,Filter) AS
(
  SELECT 'ABC','20201015','XXX'
   UNION ALL
  SELECT 'ABC','20201018','YYY'
   UNION ALL
  SELECT 'ABC','20201021','ZZZ'
   UNION ALL
  SELECT 'ABC','20201024','XYZ'
   UNION ALL
  SELECT 'ABC','20201027','XZY'
   UNION ALL
  SELECT 'ABC','20201030','YYY'
   UNION ALL
  SELECT 'ABC','20201102','ZYX'
   UNION ALL
 SELECT 'ABC','20201105','XXX'
  UNION  ALL
 SELECT 'ABC','20201108','AAA'
  UNION ALL
 SELECT 'ABC','20201111','BBB'  
)
SELECT C.NameN,C.DateAction,C.Filter,X.Price,X2.Price,
CASE 
 WHEN X2.PRICE IS NULL THEN X.PRICE
 ELSE X2.PRICE
END AS FLAG_1
FROM ActionsTable C
CROSS  APPLY
(  
  SELECT TOP 1 F.Price
   FROM FilterTable F
   WHERE F.Namen=C.NameN AND C.DateAction BETWEEN F.StartDate AND F.StopDate

)X
OUTER APPLY 
(  
  SELECT TOP 1 F.Price
   FROM FilterTable F
   WHERE F.Namen=C.NameN AND C.DateAction BETWEEN F.StartDate AND F.StopDate
   AND C.Filter=F.Filterr

)X2