How to loop in SQL from list
Posted on 2008-11-08
I need to know how to loop through a list in sql that I would provide. In short I have an array like this:
I need to create a loop for this in sql that I can run a update statement with for example:
update table set datafield =
FETCH next index value
I don't have that much experience with sql scripting and have found no solid examples on internet so far.
Any help here , greatly appreciated.