1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| begin drop table #tableTemp end
CREATE TABLE #tableTemp
(
ID char(7) NOT NULL PRIMARY KEY,
NOM VARCHAR(100) NULL,
PRENOM VARCHAR(100) NULL,
TEL_FIXE VARCHAR(100) NULL,
TEL_PORTABLE VARCHAR(100) NULL,
TEL_BUREAU VARCHAR(100) NULL,
MAIL VARCHAR(100) NULL
)
INSERT INTO #tableTemp (#tableTemp.ID,#tableTemp.NOM,#tableTemp.PRENOM)
SELECT dbo.PERSONNE.ID,dbo. PERSONNE.NOM,dbo. PERSONNE.PRENOM
FROM PERSONNE
UPDATE #tableTemp SET TEL_FIXE=
CASE
WHEN C.TYPE = 'TEL' THEN C.NUMERO
END
FROM #tableTemp S JOIN
dbo. INFOSUP_PERSONNE C ON S.ID = C.ID Collate French_CI_AS
Select *
from #tableTemp
order by ID |
Partager