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
| SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA') AND (month(F_POINTAGE.Date_Saisie) = 7 or month(F_POINTAGE.Date_Saisie) = 8)
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA') AND (month(F_POINTAGE.Date_Saisie) = 7 or month(F_POINTAGE.Date_Saisie) = 8)
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as F_POINTAGE.DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(F_POINTAGE.Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as F_POINTAGE.DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(F_POINTAGE.Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, F_POINTAGE.DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(F_POINTAGE.Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,F_POINTAGE.Date_Saisie , F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, F_POINTAGE.DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(F_POINTAGE.Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref, F_POINTAGE.DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(F_POINTAGE.Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,F_POINTAGE.Date_Saisie , F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,F_POINTAGE.Date_Saisie , F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,F_POINTAGE.Date_Saisie=Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') , F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA')
SELECT F_POINTAGE.DO_Piece, F_POINTAGE.RP_Code, F_POINTAGE.AR_ref,Format(F_POINTAGE.Date_Saisie,'dd/mm/yyyy') as DateSaisie, F_POINTAGE.DL_Qte, F_POINTAGE.Initiales
FROM SOFILEC.dbo.F_POINTAGE WHERE year(Date_Saisie)='2017' and Initiales IN ('SOFC0065','SOFC0105') and RP_Code IN('021COFCTRL','021COFEMBA') |
Partager