index > ClickOnce and Setup & Deployment Projects > How to delete last 6 months data using storedprocedure where table does'nt contains timestamp field

How to delete last 6 months data using storedprocedure where table does'nt contains timestamp field

Hi,

Can anybody help me how to delete last 1 year data from a sql server table using StoredProcedurewhere

I have two tables table1 and table2 ,table1 contains KeyId,PurchaseDate,OrderNumber columns and table2 contains KeyId,PurchaseNumber,OrderStatus columns,In these two tables KeyId is common.So can anybody help me how to delete last 6months data using storedprocedure that should delete datain two tables at a time.

Please send me reply ASAP.

Thanks in Advance

RSR001 Wednesday, June 25, 2008 3:12 AM

This is a forum for setup & deployment of .Net applications.

For help with SQLServer SQL, try posting your question here in the SQLServer T-SQL forum:

http://forums.microsoft.com/Forums/ShowForum.aspx?ForumID=85&SiteID=1

RobinS.

GoldMail.com

RobinDotNet Wednesday, June 25, 2008 4:38 AM

This is a forum for setup & deployment of .Net applications.

For help with SQLServer SQL, try posting your question here in the SQLServer T-SQL forum:

http://forums.microsoft.com/Forums/ShowForum.aspx?ForumID=85&SiteID=1