drop PROCEDURE SelectionQuotaConso
GO
CREATE Procedure SelectionQuotaConso
@DateDebut AS NVARCHAR(20), 
@DateFin AS NVARCHAR(20),
@NoBadge AS NVARCHAR(250),
@RefArticle AS INT
 AS 
BEGIN 
SELECT   TOP 100 PERCENT  Ventes.LaDate,  Ventes.Utilisateur,  DetailVente.Reference,  DetailVente.Quantite , Ventes.NumVente FROM    Ventes INNER JOIN  DetailVente ON  Ventes.NumVente =  DetailVente.NumVente GROUP BY  Ventes.LaDate,  Ventes.Utilisateur,  DetailVente.Reference,  DetailVente.Quantite , Ventes.NumVente HAVING    ( DetailVente.Reference = @RefArticle) AND ( Ventes.LaDate >= CONVERT(DATETIME, @DateDebut , 103)) AND ( Ventes.LaDate < CONVERT(DATETIME, @DateFin, 103))AND (Ventes.Utilisateur = @NoBadge) ORDER BY  Ventes.LaDate
END
GO
drop PROCEDURE SelectionQuotaConsoParFamille
GO
CREATE Procedure SelectionQuotaConsoParFamille
@DateDebut AS NVARCHAR(20), 
@DateFin AS NVARCHAR(20),
@NoBadge AS NVARCHAR(250),
@NoFamille AS INT
 AS 
BEGIN 
SELECT TOP 100 PERCENT dbo.Ventes.LaDate, dbo.Ventes.Utilisateur, dbo.DetailVente.Reference, dbo.DetailVente.Quantite, 
               dbo.DetailVente.NoFamille , dbo.Ventes.NumVente
FROM  dbo.Ventes INNER JOIN
               dbo.DetailVente ON dbo.Ventes.NumVente = dbo.DetailVente.NumVente
GROUP BY dbo.Ventes.LaDate, dbo.Ventes.Utilisateur, dbo.DetailVente.Reference, dbo.DetailVente.Quantite, dbo.DetailVente.NoFamille , dbo.Ventes.NumVente
HAVING (dbo.Ventes.LaDate >= CONVERT(DATETIME, @DateDebut, 103)) AND (dbo.Ventes.LaDate < CONVERT(DATETIME, @DateFin, 103)) AND 
               (dbo.Ventes.Utilisateur = @NoBadge) AND (dbo.DetailVente.NoFamille = @NoFamille )
ORDER BY dbo.Ventes.LaDate
END
GO