1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT A.COD_ART, A.DGN, Switch(
[TARIF1]>[TARIF2] And Format(Now(),"yyyymmdd")>=[TARIF1] And Format(Now(),"yyyymdd")>[TARIF2], [PV1],
[TARIF1]>[TARIF2] And Format(Now(),"yyyymmdd")<[TARIF1] And Format(Now(),"yyyymmdd")>=[TARIF2],[PV2],
[TARIF1]>[TARIF2] And Format(Now(),"yyyymmdd")<[TARIF1] And [TARIF2]="0",0,
[TARIF1]<[TARIF2] And Format(Now(),"yyyymmdd")<[TARIF1] And Format(Now(),"yyyymmdd")<[TARIF2],0,
[TARIF1]<[TARIF2] And Format(Now(),"yyyymmdd")>=[TARIF1] And Format(Now(),"yyyymmdd")<[TARIF2],[PV1],
[TARIF1]<[TARIF2] And Format(Now(),"yyyymmdd")>[TARIF1] And Format(Now(),"yyyymmdd")>=[TARIF2],[PV2],
[TARIF1]<[TARIF2] And [DEB_TRF_1]="0" And Format(Now(),"yyyymmdd")>=[TARIF2],[PV2],
[TARIF1]<[TARIF2] And [DEB_TRF_1]="0" And Format(Now(),"yyyymmdd")<[TARIF2],0,
[TARIF1]=[TARIF2] AND Format(Now(),"yyyymmdd")>=[TARIF1] And PV1>PV2,[PV1],
[TARIF1]=[TARIF2] AND Format(Now(),"yyyymmdd")>=[TARIF1] And PV1<PV2,[PV2],
[TARIF1]=[TARIF2] AND Format(Now(),"yyyymmdd")>=[TARIF1] And PV1=PV2,[PV2],
[TARIF1]=[TARIF2] AND Format(Now(),"yyyymmdd")<[TARIF1],0
) AS TARIFENCOURS, A.STK_DISPO, A.QTE_ATE, A.DEB_TRF_1 AS TARIF1, A.PRX_VEN_HT_1 AS PV1, A.DEB_TRF_2 AS TARIF2, A.PRX_VEN_HT_2 AS PV2, A.COD_FAM AS CF, A.COD_SOU_FAM AS CSF, A.ACC_SPL, A.LBR_2, A.VENDU_Par, IIf([COD_FAM]="03","ZZZZZZ" & [COD_ART],"_" & [COD_ART]) AS TriFamille, A.[Prix FOB], TARIFS.REFERENCE, TARIFS.TARIF, TARIFS.[PRIX X 1], TARIFS.[PRIX X 2], TARIFS.[PRIX X 3], TARIFS.[PRIX X 4], TARIFS.[PRIX X 6], TARIFS.[PRIX X 8], TARIFS.[PRIX X 12], TARIFS.[PRIX X 15], TARIFS.[PRIX X 30], TARIFS.[PRIX X 40], TARIFS.[PRIX X 60], TARIFS.[PRIX X100], TARIFS.GRP, TARIFS.[club Prix], TARIFS.[club TRUITE], TARIFS.[club CARPE], TARIFS.[club CARNA], TARIFS.[club LEURRE], TARIFS.[club CAST], TARIFS.[club SURF], TARIFS.[club VIDE1], TARIFS.[club VIDE2], TARIFS.[club VIDE3], TARIFS.[club VIDE4]
FROM dbo_ARTICLES AS A INNER JOIN TARIFS ON A.COD_ART = TARIFS.REFERENCE
ORDER BY IIf([COD_FAM]="03","ZZZZZZ" & [COD_ART],"_" & [COD_ART]); |
Partager