Originariamente inviata da
optime
posta quella giusta
Ecco la sintassi completa:
codice:
SELECT codice, matricola, data
INTO #tmp1
FROM tabella
WHERE causale<>'F'
GROUP BY codice, matricola, data
SELECT codice, matricola, data
INTO #tmp2
FROM tabella
WHERE causale='F'
GROUP BY codice, matricola, data
SELECT t1.codice, t1.matricola, t1.data
FROM #tmp1 t1 INNER JOIN #tmp2 t2
ON t1.codice=t2.codice AND t1.matricola=t2.matricola AND t1.data=t2.data
SELECT t1.codice, t1.matricola, t1.data
INTO #tmp3
FROM #tmp1 t1 INNER JOIN #tmp2 t2
ON t1.codice=t2.codice AND t1.matricola=t2.matricola AND t1.data=t2.data
UPDATE tabella
SET causale ='FH'
FROM tabella
JOIN #tmp3
ON tabella.codice = #tmp3.codice and risultati.matricola =#tmp3.matricola and risultati.data = #tmp3.data
WHERE risultati.causale = 'F'