SQL STORE PROCEDURE

[luckyguy]

I am going to create a delete procedure in my table based on the expiry date of the service agreement.But the point is i got no expiry date in my table,i only have DATE PURCHASE,MOnth Existance,and Year Duration...How can i make three of this verify with the system date?I need it urgent!thankx for ur helping..thankx...

 

[SonOfEmidec1100]

Do either of these help

Delete from MyTable WHERE datediff(mm,datepurchase,getdate()) > (YearDuration * 12)

or
Delete from MyTable WHERE MOnthExistance > (YearDuration * 12)

cjw