Hi,

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

Select

B.Id,

B.Type,

(Sum so far from A where A.Type = B.Type) as TotalSoFar

from B

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...