My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots.
SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are over 20 of them.
Can I make a stored procedure or macro that would run each one one at a time in order so I don't need to sit there and click the button on the next query? (it takes an hour to run all of them).
SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are over 20 of them.
Can I make a stored procedure or macro that would run each one one at a time in order so I don't need to sit there and click the button on the next query? (it takes an hour to run all of them).
