[ En ligne ] · Standard · Linéaire+ Comment Se Désabonner Du Site Openspace ?, comment se désabonner du site openspace

[joez]

???

[Arsenik_]

QUOTE

PARSE=AddQueryDatabase(GetSQLString("SELECT Ctbl_Doc_C00.Dt_Doc, Format([Dt_Doc],'mm') AS Mois, Ctbl_Doc_C00.TypeData, Ctbl_Doc_C00.Id_Cli, Atbl_Cli.Lbl_Cli, Ctbl_Doc_Cli_Lig.ID_Prd, Ctbl_Doc_Cli_Lig.Qte, Ctbl_Doc_Cli_Lig.Lig_HT_E, Atbl_Prd_Fin.Tech_02 FROM ((Ctbl_Doc_C00 INNER JOIN Ctbl_Doc_Cli_Lig ON Ctbl_Doc_C00.Id_Doc_Cli = Ctbl_Doc_Cli_Lig.Id_Doc_Cli) INNER JOIN Atbl_Cli ON Ctbl_Doc_C00.Id_Cli = Atbl_Cli.Id_Cli) INNER JOIN Atbl_Prd_Fin ON Ctbl_Doc_Cli_Lig.ID_Prd = Atbl_Prd_Fin.Id_Prd WHERE (((Ctbl_Doc_C00.Dt_Doc) Between %1% And %2%) AND ((Ctbl_Doc_C00.TypeData)=50 Or (Ctbl_Doc_C00.TypeData)=60) AND ((Ctbl_Doc_C00.Id_Cli) Between %3% And %4%) AND ((Ctbl_Doc_Cli_Lig.ID_Prd) Between %5% And %6%))"),"Z1_VntAnl_A_2356896963") GetSQLString("TRANSFORM Sum(Z1_VntAnl_A_2356896963.Qte) AS Valeur SELECT Z1_VntAnl_A_2356896963.Lbl_Cli, Z1_VntAnl_A_2356896963.ID_Prd, Z1_VntAnl_A_2356896963.Tech_02, Sum(Z1_VntAnl_A_2356896963.Qte) AS [Total de Qte], Sum(Z1_VntAnl_A_2356896963.Lig_HT_E) AS SommeDeLig_HT_E FROM Z1_VntAnl_A_2356896963 GROUP BY Z1_VntAnl_A_2356896963.Lbl_Cli, Z1_VntAnl_A_2356896963.ID_Prd, Z1_VntAnl_A_2356896963.Tech_02 ORDER BY Z1_VntAnl_A_2356896963.Lbl_Cli, Z1_VntAnl_A_2356896963.ID_Prd PIVOT Z1_VntAnl_A_2356896963.Mois In (01,02,03,04,05,06,07,08,09,10,11,12) ")

c'est une des plus petites.... elle est belle non, c'est juste une partie de l'affichage des ventes

Sha> c vrai je suis sex a onduler de la sorte