Buscar dato en cadena Separada por Comas

[Libras]

y esto no te sirve:

Código SQL:

CREATE TABLE #temp1(
id INT,
value1 VARCHAR(20)
 
)
 
 
CREATE TABLE #temp2(
id INT,
value2 VARCHAR(20)
)
 
 
INSERT INTO #temp1 VALUES (1,'1;2;;;')
INSERT INTO #temp1 VALUES (2,'1;1;2;;')
INSERT INTO #temp2 VALUES (1,'1;-60;2;;')
INSERT INTO #temp2 VALUES (2,'1;10;30;;')
 
SELECT value1,value2 ,
(SELECT DATA FROM [SplitApplication](value2) WHERE id=(SELECT id FROM [SplitApplication](value1) WHERE DATA LIKE '%2%')) AS dato FROM #temp1 AS t1
INNER JOIN #temp2 AS t2 ON (t1.id=t2.id)
 
 
value1      value2     Dato
1;2;;;  1;-60;2;;   -60
1;1;2;; 1;10;30;;   30
 

saludos!