1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| declare @rq1 int;
@rq1=SELECT DISTINCT
T_HST_POSTE.NumSalarie, T_HST_POSTE.CodePoste, T_HST_POSTE.InfoEnCours, T_COMPREQUISE_POSTE.CodePoste AS codepostereq,
T_COMPREQUISE_POSTE.Niveau, T_COMPREQUISE_POSTE.Ponderation, T_COMPREQUISE_POSTE.Code AS CodeReq,
T_COMPACQUISE.Code AS CodeAcq
FROM T_HST_POSTE INNER JOIN
T_COMPREQUISE_POSTE ON T_HST_POSTE.CodePoste = T_COMPREQUISE_POSTE.CodePoste INNER JOIN
T_COMPACQUISE ON T_HST_POSTE.NumSalarie = T_COMPACQUISE.NumSalarie
WHERE (T_HST_POSTE.InfoEnCours = '1') AND (T_COMPREQUISE_POSTE.Code NOT IN (T_COMPACQUISE.Code))SELECT DISTINCT
T_HST_POSTE.NumSalarie, T_HST_POSTE.CodePoste, T_HST_POSTE.InfoEnCours, T_COMPREQUISE_POSTE.CodePoste AS codepostereq,
T_COMPREQUISE_POSTE.Niveau, T_COMPREQUISE_POSTE.Ponderation, T_COMPREQUISE_POSTE.Code AS CodeReq,
T_COMPACQUISE.Code AS CodeAcq
FROM T_HST_POSTE INNER JOIN
T_COMPREQUISE_POSTE ON T_HST_POSTE.CodePoste = T_COMPREQUISE_POSTE.CodePoste INNER JOIN
T_COMPACQUISE ON T_HST_POSTE.NumSalarie = T_COMPACQUISE.NumSalarie
WHERE (T_HST_POSTE.InfoEnCours = '1') AND (T_COMPREQUISE_POSTE.Code NOT IN (T_COMPACQUISE.Code))
if @Rq1 is true begin ... |
Partager