I'm hoping someone can help. I wondering if its possible to get a sum of a column from a table you are inserting into... example pseudo code below
insert into A
(Sum so far from A where A.Type = B.Type) as TotalSoFar
In this way, as records are inserted i can get a total of a column for all the records already inserted with the same type...
Is this possible, and if not are there any workarounds that will achieve the same result?
thanks in advance...