Citation :
if exists (select * from sysobjects where id = object_id('dbo.DeFactEvenements' ) and sysstat & 0xf = 4)
drop procedure dbo.DeFactEvenements
GO
CREATE PROCEDURE DeFactEvenements @DateFact varchar (8),
@DosDeb integer,
@DosFin integer
AS
SELECT * FROM Evenements WHERE NumDossier >= @DosDeb AND NumDossier <= @DosFin AND Type in ('VD' ,'CT','CA','IM','AV' ) AND DateFacture <= @DateFact AND Etat = 1 ORDER BY NumDossier, DateFacture, SerieFac, RegrptType
GO
|