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.
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
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
Last activity: Jul 3, 2025, 03:08 PM