Sample Header Ad - 728x90

SQL - Update certain database records with a loop

0 votes
1 answer
4370 views
I have a certain IDs in a table that I would like to change a column value from false to true. How can I do a loop that goes through the specific IDs given and changes a column value from false to true? I’m not very familiar with SQL and the only option that came to mind is through a loop. This is a sample of my data. enter image description here Basically we have a stored procedure to change the “description” of the BetGenerationBetID given from FAILED to SUCCESSFUL example, the below will update the description of BetGenerationBetID 265809596 to SUCCESSFUL enter image description here With the above I can only update a record each time. So I want something that I can give all BetGenerationBetIDs that I want to update and changes the description of each ID at once.
Asked by chrissult (19 rep)
Apr 10, 2019, 12:03 PM
Last activity: Jul 3, 2025, 03:08 PM