随着时间的推移遇到递归SQL的问题

I'm rewriting one of our inhouse financial systems. What I'm setting up is that this new system takes a snapshot of the order table every month and date that snapshot. This part works great. I'm rewriting one of our inhouse financial syst