Bonjour,

Je suis actuellement en train de migrer une base Access vers SQL server.
Je dois donc réécrire une bonne partie de mes ordres SQL.
Je bute sur celui-là :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
Select distinct Count(tblCCMAction.IdAction) AS [Nb of actions] , 
Count(IIF(tblCCMAction.ProcessTime <= tblCCMAction.Target, 1, NULL)) AS [Nb actions on time] , 
Count(IIF(tblCCMAction.ProcessTime <= tblCCMAction.Target, 1, NULL)) / iif(Count(1)=0, 1, Count(tblCCMAction.IdAction)) AS [% actions on timePOURCENTAGE], 
Count(IIF(tblCCMAction.ProcessTime BETWEEN 0 AND 120, 1, NULL)) AS [<2h] , 
Count(IIF(tblCCMAction.ProcessTime BETWEEN 121 AND 240, 1, NULL)) AS [<4hours] , 
Count(IIF(tblCCMAction.ProcessTime BETWEEN 241 AND 1440, 1, NULL)) AS [<1d] , 
Count(IIF(tblCCMAction.ProcessTime BETWEEN 1441 AND 2880, 1, NULL)) AS [<2d] , 
Count(IIF(tblCCMAction.ProcessTime > 2880, 1, NULL)) AS [>2 days] 
FROM (TblCCMDossier INNER JOIN TblCCMAction ON TblCCMDossier.IdDossier = TblCCMAction.IdDossier) 
where TblCCMDossier.CloseDate  >= #05/01/2007# 
and TblCCMDossier.CloseDate  <= #06/11/2007#
Comment réécrire les count ?
Merci.