Discussion :

[bigmousse69]

Bonjour,
je suis novice en sql et j'aimerais savoir si ce code est du SQL???

Code :

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

1
2
3
4
5
6
7
8
9
SELECT avg(T2.ItmsGrpCod) as 'famille', T1.CardCode, T0.ItemCode, avg(T2.OnHand) as 'stock'
, sum(T0.Quantity) as 'conso', avg(T2.IsCommited) as 'En Cde', avg(T2.OnHand)/sum(T0.Quantity)*30 as 'st en j'
, avg(T0.Price) as 'prix', avg(T2.SVolume*T2.onhand) as 'Vol. stock', sum(T2.SVolume*T0.Quantity) as 'Vol. cons.', avg(T2.U_GTI_A009) as 'Série Eco'
, avg(T2.U_GTI_A009*T2.SVolume) as 'Vol. Série Eco'  
FROM DLN1 T0  
INNER JOIN ODLN T1 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
WHERE T1.DocDate >dateadd(day,-30,getdate())  
GROUP BY T0.ItemCode, T1.CardCode ORDER BY T0.ItemCode

Merci
mousse

[ced]

Bonjour,

Oui, c'est bien du SQL .

ced