Run many large update queries in the right order one at a time possible?

Dr. Logic

Board Regular
Joined
Jul 13, 2005
Messages
218
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).
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
707
Yes, as the video shows.
That is about the only use I make of macroes :D
 

Forum statistics

Threads
1,086,259
Messages
5,388,728
Members
402,137
Latest member
pkulkarni

Some videos you may like

This Week's Hot Topics

Top