Have a master / detail situation. How do I write a query, which would sum
detail records  and write into a master record? And that for each master
record.
please, advise

"Andrej Bivic" <andrej.bivic@abitrade.si> wrote in message
news:9A24B40C-EE50-4280-A041-CE81641AE34D@news.elevatesoft.com...
> Have a master / detail situation. How do I write a query, which would sum
> detail records  and write into a master record? And that for each master
> record.

The obvious question is "why?". But assuming you need that, I like to use a
script, something like

selec mast_id, sum(field) as d_total
into memory\temp
from detail
group by mast_id;
create index byid on memory\temp (mast_id);
update master set m_total = d_total
from master
join memory\temp on id = mast_id;
drop table memory\temp;

Robert

> please, advise
>