sql server split a string of id into a table without split string code example
Example: create table split string function in sql server
SELECT
first_name,
last_name,
value phone
FROM
sales.contacts
CROSS APPLY STRING_SPLIT(phones, ',');