8 : 47   20 . 10 .2006insert into [oper]
      ([Kol],
       [Type],
       [nomtov])
select  0 ,
       "Приход",
       [id]
from   [Tovar] T1
where  (select count(*) from [Oper] O1 where O1.[nomtov]=T1.[id] and O1.[Type]="Приход")= 0 ;

insert into [oper]
      ([Kol],
       [Type],
       [nomtov])
select  0 ,
       "Расход",
       [id]
from   [Tovar] T1
where  (select count(*) from [Oper] O1 where O1.[nomtov]=T1.[id] and O1.[Type]="Расход") =  0 ;

insert into [oper]
      ([Kol],
       [Type],
       [nomtov])
select  0 ,
       "Резервирование",
       [id]
from   [Tovar] T1
where  (select count(*) from [Oper] O1 where O1.[nomtov]=T1.[id] and O1.[Type]="Резервирование") =  0 ;

update [tovar]
set 
[kol]=
(select Sum(kol) from [oper] o 
where o.[type]='Приход' and o.[nomtov]=[tovar].[id])-
(select Sum(kol) 
from [oper] o where o.[type]='Расход' and o.[nomtov]=[tovar].[id]),
[svobodno]=
(select Sum(kol) from [oper] o 
where o.[type]='Приход' and o.[nomtov]=[tovar].[id])-
(select Sum(kol) 
from [oper] o where o.[type]='Расход' and o.[nomtov]=[tovar].[id])-
(select Sum(kol) 
from [oper] o where o.[type]='Резервирование' and o.[nomtov]=[tovar].[id]),
[rezerv]=
(select Sum(kol) 
from [oper] o where o.[type]='Резервирование' and o.[nomtov]=[tovar].[id])
where dir=false;

delete from oper
where kol= 0 ;