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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
CREATE PROCEDURE requete
(
@IdDescom INT ,
@Code INT,
@Niveau INT,
@ponderation INT
)
AS
IF
SET SELECT CodePoste
FROM T_HST_POSTE
WHERE (CodePoste IS NOT NULL)
then
if
SELECT DISTINCT CodePoste
FROM T_COMPREQUISE_POSTE
WHERE (CodePoste in (SELECT CodePoste FROM T_COMPACQUISE));
then
INSERT INTO T_COMPACQUISE
(IdDescomp,
Code,
Niveau,
ponderation)
VALUES
(@IdDescom,
@Code,
@Niveau,
@ponderation)
else
if
SELECT T_COMPACQUISE.NumSalarie,T_COMPACQUISE.Code,T_COMPACQUISE.IdDescomp
FROM T_COMPACQUISE inner join
T_COMPREQUISE_POSTE on T_COMPACQUISE.Code=T_COMPREQUISE_POSTE.Code
AND T_COMPACQUISE.Niveau<T_COMPREQUISE_POSTE.Niveau
then
UPDATE T_COMPACQUISE
Set Niveau=Niveau
WHERE Niveau IN (select Niveau FROM T_COMPACQUISE) |
Partager