If you have two queries and you have to execute one after another with some amount of delay, then that is possible in SQL Server.
Lets say, your first query fills up the table with some records. Lets assume that, you will get some responses based on this records which will fill other table. Now your second query should run based on the responses table. Then you can make a delay for quite amount of time.
Lets see a simple example of using waitfor and delay in SQL Server:
Syntax:
WAITFOR DELAY 'HH:MM:SS'
where HH:MM:SS - Hours, minutes and seconds respectively.
Example:
SELECT GETDATE() CurrentTime
WAITFOR DELAY '00:00:05'
SELECT GETDATE() CurrentTime
Output:
CurrentTime
2009-03-25 14:47:
13.797
CurrentTime
2009-03-25 14:47:
18.800