I am trying to build multiple neural networks in sql. I'm doing this by looping through rows in a table using a cursor ( which I know most sql gurus hate, but this isn't where I'm getting stuck) and based on on a calculation for each row I update the values which make up my neural network which I store in another table. Doing it this way takes way too long so I stored my neural network's values as variables and this works well since the values that must be updated are stored in memory. However, I aim to make this a scalable solution so that a multitude of of neural nets can be developed which would require multiple variable declarations. Being able to store these values in a table and cache this table would work well. I know ssis allows one to cache tables but then they're read only lookup tables, is there any way to cache a table so that it's updatable?

Thanks in advance