1 2 3 4 5 6 7 8 9 10 11 12 13
| 1
2
3
4
5
<add key="selection_mail" value=" Select libelle_message, Message, convert(varchar(100),date_message,103) as Date_Mail ," +
" convert(varchar(30),heure_message,108) as heure_mail , frequence_message , Date_Fixe From mail " +
" where cast(datediff(day,date_message,date_creation) as int)%cast(frequence_message as int)='0' " +
" and datepart(hour,heure_message)=datepart(hour,getdate())" +
" and datepart(minute,heure_message) BETWEEN datepart(minute,getdate()) AND datepart(minute,getdate())+10 " /> |
Partager