0
I need to do a massive daily processing where I need to read a table my row by row and apply some rules and in the end update a column from another table. What would be the best way to make this process ? A store Procedure containing a cursor in table A, and after the rules an update in table B ? A Rigger in some way ? I didn’t want to make an API for it, I wanted to make the bank solve itself, what would be the best strategy ?
Few data but in theory a Procedure called by a schedulle , but " read a table my row by row and apply some rules" the table may have 5 or 5,000.00 of lines and may be 3 or 3456 rules ...
– Motta