Is there a sleep function in VS script?

in most of unix shell scrip (c, korn), you can sleep(60). that is it.

Brian's solution solves the problem nicely. But in general, if I want to assign the result of a stored procedure to a local variable, is there a better way than...

Any simpler way? or SQL server is just that stupid.

Your suggestion works only for subquery. What if I already know the keys? Of cause, one way to do it is to iterate over the keys in each select like

foreach...