I am working with a population of items that goes through conversions from 1 type to another based on percentages in a table.
The conversion hapen iteratively until there are conversions left.
What i would like to be able to do input a type and population and return a table of the converted population.
I’m really looking for ideas on how to approach this (using SQL Server). I’ll give a simple example below.