weeodett
Last Activity: Oct 9 '07, 09:50 PM
Joined: Jan 5 '07
Location:
-
Thank you very much!! -
Delete rows from one tbl based on whether row in another tbl?
How can I delete about 9000 rows from one table (Table1) based on whether they also are in another table (Table2)? I tried the following:
DELETE FROM Table1 T
WHERE T.DocNo = Table2.DocNo
and T.DocTyp = Table2.DocTyp
and T.DocLn = Table2.DocLn -
weeodett replied to How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerGREAT!!! Thanks so much for your help!!!!Leave a comment:
-
weeodett replied to How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerYes, I can get to Ent Mgr. I believe this should be done daily.Leave a comment:
-
weeodett replied to How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerI just tested the selects you sent, and yes, they did work. But I don't know how to then delete the records?Leave a comment:
-
weeodett replied to How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerThank you, iburyak. I am truly a novice at SQL. What do I need to do next in order to get this to then delete the records from the original table, and automate this?Leave a comment:
-
weeodett replied to How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerYes, there is a unique RecordIDLeave a comment:
-
weeodett started a topic How to automate deletion of oldest rows when table reaches certain number of rows?in SQL ServerHow to automate deletion of oldest rows when table reaches certain number of rows?
Is there a way to automate the deletion of the oldest rows in a transaction log file when the file reaches a certain number of rows? Currently, we are simply deleting the oldest rows manually every so often. But we would like to put something in place that will do this automatically. The reason for doing this is to ultimately improve the application's performance that writes the transactions to this file. When the file gets to be over about 60,000...
No activity results to display
Leave a comment: