USP For 4 weeks

CREATE PROCEDURE FourWeeks @Flag BIT OUTPUT

AS

BEGIN

DECLARE @Count AS INT

SELECT @Count = COUNT(*) FROM YourTable WHERE YourDateField >= DATEADD(d, -28, GETDATE())

IF @Count = 0 OR @Count IS NULL

SET @Bit = 0

ELSE

SET @Bit = 1

END

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu