1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| IF (@modifiedbyname = @teleprospTmp) AND(
(@new_resultatappel1= 4 AND (CONVERT(DATETIME,@new_dateappel1,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel2= 4 AND (CONVERT(DATETIME,@new_dateappel2,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel3= 4 AND (CONVERT(DATETIME,@new_dateappel3,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel4= 4 AND (CONVERT(DATETIME,@new_dateappel4,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel5= 4 AND (CONVERT(DATETIME,@new_dateappel5,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel6= 4 AND (CONVERT(DATETIME,@new_dateappel6,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel7= 4 AND (CONVERT(DATETIME,@new_dateappel7,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel8= 4 AND (CONVERT(DATETIME,@new_dateappel8,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel9= 4 AND (CONVERT(DATETIME,@new_dateappel9,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel10= 4 AND (CONVERT(DATETIME,@new_dateappel10,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel11= 4 AND (CONVERT(DATETIME,@new_dateappel11,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel12= 4 AND (CONVERT(DATETIME,@new_dateappel12,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel13= 4 AND (CONVERT(DATETIME,@new_dateappel13,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel14= 4 AND (CONVERT(DATETIME,@new_dateappel14,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103)))
OR (@new_resultatappel15= 4 AND (CONVERT(DATETIME,@new_dateappel15,103) between CONVERT(DATETIME,@datedebut_semaine,103) and CONVERT(DATETIME,@datefin_semaine,103))) )
SET @res = @res + 1 |
Partager