I’m a retired analyst/developer. It’s literally been 20 years since I attempted to develop anything, programming wise.

That being said, I’m writing a program with sections of repeatable code. In SQL itself, is there some type of “perform” command so I can “execute” a section of code repeatedly?

Thanks,

David Mc

Repetitive code example:

Start of my example

 Declare Table_A
 Read a database record into Table_A
 Select a field in Table_A for further processing

End of my example

Can I just create a stored procedure and then “exec” it?