Post reply

Stored Procedure keeps looping until it returns a specific value?

  • August 8, 2018 at 3:32 am

    #414842

    Hi,

    So I have a SP that is fairly simple - searches some tables for events/values are either returns 0 or 1 depending on what it finds.

    What is needed is  to have it loop until it returns 0? Ideally at a specified time interval. Not sure of the syntax

    Also, is there any risk to doing it this way (rather than say running the existing SP at the same interval using a batch scheduler solution)?

  • August 8, 2018 at 6:49 am

    #2000777

    Looping a procedure like that (which is possible, look up a WHILE loop), will lead to all sorts of problems. I wouldn't recommend it at all. Instead, from what you're saying, you need to look up what a trigger is. Then, when something changes from 1 to 0, it automatically does something... I think. Just guessing because the requirements here are pretty vague.

    Don't loop the query.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply