I'm working on a graph for a client that needs to show growth rates for a population. I have the starting population and the date of that starting population. I know the annual growth rate is 30%. What I need is to take that growth and be able to calculate the growth of the population for a given date in the future.
I.e. Starting Population 100, Growth Rate 30%, Start Date 1/1/2010
Population on 1/1/2011 would be 130.
How would I calculate the population of the dataset say for 6/1/2010?
Or 6/1/2013 ?
MS SQL Function, Stored Procedure, etc