Discussion :

[lea022]

Bonjour Voici ma requête SQL
Pouvez vous m'indiquer comment faire pour la transformer en requête d'ajout afin d'alimenter une de mes bases
Merci par avance

________________________________________________________________

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
SELECT  [Entrer le collaborateur] AS Collaborateur, erreur AS TYPE_ANOMALIE 
    ,   SUM(somme) AS TOTAL_PAR_ANOMALIE
FROM    (   SELECT  [Ano Grave 1]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
            WHERE  [Ano Grave 1] IS NOT NULL AND[Collaborateur]=[Entrer le collaborateur] AND [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Grave 1] 
        UNION ALL
            SELECT  [Ano Grave 2]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
             WHERE  [Ano Grave 2] IS NOT NULL AND [Collaborateur]=[Entrer le collaborateur] AND [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Grave 2]
        )   AS Erreurs
GROUP BY Erreur;
 
UNION ALL
 
SELECT  [Entrer le collaborateur] AS Collaborateur, erreur AS TYPE_ANOMALIE 
    ,   SUM(somme) AS TOTAL_PAR_ANOMALIE
FROM    (   SELECT  [Ano Gênante 1]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
            WHERE  [Ano Gênante 1] IS NOT NULL AND [Collaborateur]=[Entrer le collaborateur] AND [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Gênante 1] 
        UNION ALL
            SELECT  [Ano Gênante 2]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
             WHERE  [Ano Gênante 2] IS NOT NULL AND [Collaborateur]=[Entrer le collaborateur] AND [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Gênante 2]
        )   AS Erreurs
GROUP BY Erreur;
 
UNION ALL SELECT  [Entrer le collaborateur] AS Collaborateur, erreur AS TYPE_ANOMALIE 
    ,   SUM(somme) AS TOTAL_PAR_ANOMALIE
FROM    (   SELECT  [Ano Mineure 1]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
            WHERE  [Ano Mineure 1] IS NOT NULL AND [Collaborateur]=[Entrer le collaborateur] AND  [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Mineure 1] 
        UNION ALL
            SELECT  [Ano Mineure 2]   AS ERREUR
                ,   count(*)        AS somme
            FROM    [SUPERVISION PERMANENTE]
             WHERE  [Ano Mineure 2] IS NOT NULL AND [Collaborateur]=[Entrer le collaborateur] AND [Date] BETWEEN [Début] AND [Fin] 
            GROUP BY [Ano Mineure 2]
        )   AS Erreurs
GROUP BY Erreur;

[al1_24]

Il suffit d'ajouter ceci au début de la requête :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

INSERT INTO matable (liste colonnes, ...)