Please can you help?
I am new to SQL (although not to programming) and am confused how to
tackle the following problem, which is a much cut down version of my
real-life issues but hopefully demonstrates the point?
Essentially I need to pro-rata indiviual records pro-rata to some
lookup value in an associated table. I can link the tables OK but what
I get stuck with is the pro-ratering of the values primarily because
the "factor" is dependant on the sum of the records, but once the
factor is calculated, the records have past. Confused? perhaps an
example would help.