SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
 Apr 11 2022 16:24:07 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



SELECT compatibility_level  
FROM sys.databases WHERE name = suser_name();


compatibility_level


150


with data
  as (select 'model_check_holding' as col1,'1,2,3,4,5' as str union all
      select 'model_cash_holding'  as col1,'5,8,9' as str 
     )
    ,split_data
     as (select *
           from data
         cross apply string_split(str,',') 
        )
     ,user_input
      as(select '2,8,1' as input_val)
select *
 from split_data
where value in (select x.value 
                 from user_input 
                 cross apply string_split(input_val,',') x
                ) 


col1
str
value


model_check_holding
1,2,3,4,5
1

model_check_holding
1,2,3,4,5
2

model_cash_holding
5,8,9
8

col1	str	value
model_check_holding	1,2,3,4,5	1
model_check_holding	1,2,3,4,5	2
model_cash_holding	5,8,9	8