I have to query more than 400 thousand records in the IN clause. It turns out that I can not do everything at once because I can crash the system of my company. So I have to run at a specific time and every 5,000 at a time. But I do not know an effective way to do that. I wanted to do a JOB, but I would have to do a lot of JOBS.
Can I make a WHILE so that it runs from 5,000 to 5,000? I use SQL Server .