|
Posted by Afshin on August 13, 2008, 6:37 pm
Please log in for more thread options
You can use this query - ALWAYS MAKE A BACKUP OF DATABASE. In this query
you can change the DayBefore = 30 to the number you want like 60 or 90.
Declare @DayBefore Int
Set @DayBefore = 30
Begin Transaction
Update [OrderEntry] Set QuantityOnOrder = 0 Where OrderID In
(Select ID From [Order]
Where Type = 3 And Closed = 0 And Datediff(Day,[Time],Getdate()) >
@DayBefore)
Update [Order] Set Closed = 1 Where ID In
(Select ID From [Order]
Where Type = 3 And Closed = 0 And Datediff(Day,[Time],Getdate()) >
@DayBefore)
Commit Transaction
Afshin Alikhani - afshin@retailrealm.co.uk
Retail Realm
= = = = = = =
> how can I remove old quotes that were not been removed after there
> experation
> date?
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap