Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sinjin67
Yak Posting Veteran
53 Posts |
 Posted - 2008-12-22 : 18:43:25
|
| I am have trouble with the syntax and was hoping someone mightsee the error. I think I am close on this.. I am trying to getmy function to delete all records over 90 days and have a archivevalue of 1. It works fine without the "and arc = 1" varQuery = "DELETE FROM Label01 WHERE DATEDIFF(dd,date,GETDATE()<=90 and arc=1" Any help would be great..thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sinjin67
Yak Posting Veteran
53 Posts |
Posted - 2008-12-22 : 19:00:12
|
| Thanks... Been working on it for a bit and just could,nt see it anymore..Thanks again... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
syntax help...