USP For 4 weeks

Hi ODIAZ0305,

I think Sebastian gave us a great method, since we need to find the data values which older than 4 weeks, we just need to change ">=" as "<", for you convenience, I listed the codes here again.

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 @Flag = 0  
ELSE  SET @Flag = 1 
END  

---

Allen Li

TechNet Community Support