Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionUPDATE TBL_ANALYSE T2 Set T2.MINI = (Select MIN(T1.NBOCC) From /* Recherche des représentations de chaque tranche horaire pour l'article mis à jour sur T2*/ (Select ARTICLE, Substring(DATEHEURE from 9 for 2) as TRANCHE, Count(Substring(DATEHEURE from 9 for 2)) as NBOCC From TBL_VENTES Where ARTICLE = T2.ARTICLE Group by ARTICLE, TRANCHE) T1 Group by T1.ARTICLE), T2.MAXI = (Select MAX(T2.NBOCC) From (Select ARTICLE, Substring(DATEHEURE from 9 for 2) as TRANCHE, Count(Substring(DATEHEURE from 9 for 2)) as NBOCC From TBL_VENTES Where ARTICLE = T2.ARTICLE Group by ARTICLE, TRANCHE) T2 Group by T2.ARTICLE);
UPDATE TBL_ANALYSE T0 Set T0.MINI = (Select MIN(T1.NBOCC) From /* Recherche des représentations de chaque tranche horaire pour l'article mis à jour sur T0*/ (Select ARTICLE, Substring(DATEHEURE from 9 for 2) as TRANCHE, Count(Substring(DATEHEURE from 9 for 2)) as NBOCC From TBL_VENTES Where ARTICLE = T0.ARTICLE Group by ARTICLE, TRANCHE) T1 Group by T1.ARTICLE), T0.MAXI = (Select MAX(T2.NBOCC) From (Select ARTICLE, Substring(DATEHEURE from 9 for 2) as TRANCHE, Count(Substring(DATEHEURE from 9 for 2)) as NBOCC From TBL_VENTES Where ARTICLE = T0.ARTICLE Group by ARTICLE, TRANCHE) T2 Group by T2.ARTICLE);