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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| SELECT Table_planification.N°, Table_planification.Etape1, Table_planification.Etape2, Table_planification.Etape3, Table_planification.Etape4, Table_planification.Etape5, Table_planification.Etape6, Table_planification.Etape7, Table_planification.Etape8,
Table_planification.C1, Table_planification.C2, Table_planification.C3, Table_planification.C4, Table_planification.C5, Table_planification.C6,
Table_planification.C7, Table_planification.C8, Table_planification.C9, Table_planification.C10, Table_planification.C11, Table_planification.C12,
Table_planification.C13, Table_planification.C14, Table_planification.C15, Table_planification.C16, Table_planification.C17, Table_planification.C18,
Table_planification.C19, Table_planification.C20, Table_planification.C21, Table_planification.C22, Table_planification.C23, Table_planification.C24,
Table_planification.C25, Table_planification.C26, Table_planification.C27, Table_planification.C28, Table_planification.C29, Table_planification.C30,
Table_planification.C31, Table_planification.C32, Table_planification.C33, Table_planification.C34, Table_planification.C35, Table_planification.C36,
Table_planification.C37, Table_planification.C38, Table_planification.C39, Table_planification.C40, Table_planification.C41, Table_planification.C42,
Table_planification.C43, Table_planification.C44, Table_planification.C45, Table_planification.C46, Table_planification.C47, Table_planification.C48,
Table_planification.C49, Table_planification.C50, Table_planification.C51, Table_planification.C52,
Switch([C52]="RAS","1",[C52]="CC","2",[C52]="X","3",
[C51]="RAS","1",[C51]="CC","2",[C51]="X","3",
[C50]="RAS","1",[C50]="CC","2",[C50]="X","3",
[C49]="RAS","1",[C49]="CC","2",[C49]="X","3",
[C48]="RAS","1",[C48]="CC","2",[C48]="X","3",
[C47]="RAS","1",[C47]="CC","2",[C47]="X","3",
[C46]="RAS","1",[C46]="CC","2",[C46]="X","3",
[C45]="RAS","1",[C45]="CC","2",[C45]="X","3",
[C44]="RAS","1",[C44]="CC","2",[C44]="X","3",
[C43]="RAS","1",[C43]="CC","2",[C43]="X","3",
[C42]="RAS","1",[C42]="CC","2",[C42]="X","3",
[C41]="RAS","1",[C41]="CC","2",[C51]="X","3",
[C40]="RAS","1",[C40]="CC","2",[C40]="X","3",
[C39]="RAS","1",[C39]="CC","2",[C39]="X","3",
[C38]="RAS","1",[C38]="CC","2",[C38]="X","3",
[C37]="RAS","1",[C37]="CC","2",[C37]="X","3",
[C36]="RAS","1",[C36]="CC","2",[C36]="X","3",
[C35]="RAS","1",[C35]="CC","2",[C35]="X","3",
[C34]="RAS","1",[C34]="CC","2",[C34]="X","3",
[C33]="RAS","1",[C33]="CC","2",[C33]="X","3",
[C32]="RAS","1",[C32]="CC","2",[C32]="X","3",
[C31]="RAS","1",[C31]="CC","2",[C31]="X","3",
[C30]="RAS","1",[C30]="CC","2",[C30]="X","3",
[C29]="RAS","1",[C29]="CC","2",[C29]="X","3",
[C28]="RAS","1",[C28]="CC","2",[C28]="X","3",
[C27]="RAS","1",[C27]="CC","2",[C27]="X","3",
[C26]="RAS","1",[C26]="CC","2",[C26]="X","3",
[C25]="RAS","1",[C25]="CC","2",[C25]="X","3",
[C24]="RAS","1",[C24]="CC","2",[C24]="X","3",
[C23]="RAS","1",[C23]="CC","2",[C23]="X","3",
[C22]="RAS","1",[C22]="CC","2",[C22]="X","3",
[C21]="RAS","1",[C21]="CC","2",[C21]="X","3",
[C20]="RAS","1",[C20]="CC","2",[C20]="X","3",
[C19]="RAS","1",[C19]="CC","2",[C19]="X","3",
[C18]="RAS","1",[C18]="CC","2",[C18]="X","3",
[C17]="RAS","1",[C17]="CC","2",[C17]="X","3",
[C16]="RAS","1",[C16]="CC","2",[C16]="X","3",
[C15]="RAS","1",[C15]="CC","2",[C15]="X","3",
[C14]="RAS","1",[C14]="CC","2",[C14]="X","3",
[C13]="RAS","1",[C13]="CC","2",[C13]="X","3",
[C12]="RAS","1",[C12]="CC","2",[C12]="X","3",
[C11]="RAS","1",[C11]="CC","2",[C11]="X","3",
[C10]="RAS","1",[C10]="CC","2",[C10]="X","3",
[C9]="RAS","1",[C9]="CC","2",[C9]="X","3",
[C8]="RAS","1",[C8]="CC","2",[C8]="X","3",
[C7]="RAS","1",[C7]="CC","2",[C7]="X","3",
[C6]="RAS","1",[C6]="CC","2",[C6]="X","3",
[C5]="RAS","1",[C5]="CC","2",[C5]="X","3",
[C4]="RAS","1",[C4]="CC","2",[C4]="X","3",
[C3]="RAS","1",[C3]="CC","2",[C3]="X","3",
[C2]="RAS","1",[C2]="CC","2",[C2]="X","3",
[C1]="RAS","1",[C1]="CC","2",[C1]="X","3",
) AS Variation
FROM Table_planification; |
Partager