SELECT
 (T_SAL.MatriculeSalarie + ' ' + isnull(T_SAL.Nom, '') + ' '  + isnull(T_SAL.Prenom, '') ) as Col1,
  'Date de fin de contrat : '+ CONVERT(VARCHAR(12),T_HST_CONTRAT.DateFinContrat, 113) as Col2
FROM
  T_PAI,
  T_SAL
  LEFT OUTER JOIN T_HST_CONTRAT ON T_HST_CONTRAT.NumSalarie=T_SAL.SA_CompteurNumero
                  AND T_HST_CONTRAT.InfoEnCours=1
  LEFT OUTER JOIN T_NATUREDECONTRAT ON T_HST_CONTRAT.CodeNatureDeContrat = T_NATUREDECONTRAT.Code 
Where  ( CURRENT_TIMESTAMP >= DATEADD(DAY,ISNULL(-%NbJoursAvant%,0),T_HST_CONTRAT.DateFinContrat)
		 and CURRENT_TIMESTAMP <= DATEADD(DAY,ISNULL(%NbJoursApres%,0),T_HST_CONTRAT.DateFinContrat)
		 and T_NATUREDECONTRAT.NatureDeContrat = 1
		)

Order by T_SAL.MatriculeSalarie