/*
truncate table Reserved;
with cte (i) as
(
	select 1 union all
	select i+1 from cte
)
insert Reserved
select top(30)
	abs(convert(int,convert(binary(4),newid())))%10 as C_Obj,
	abs(convert(int,convert(binary(4),newid())))%50 as C_Tov,
	dateadd(second,-abs(convert(int,convert(binary(4),newid())))%1000,'20170101') as D_Reg,
	abs(convert(int,convert(binary(4),newid())))%50 as N_Reg,
	convert(money,(abs(convert(int,convert(binary(4),newid())))%10000))/100 as Kol_vo
from cte
option(maxrecursion 0)
*/
declare @C_Obj int=1,@C_Tov int=1
select top(1) @C_Obj = C_Obj, @C_Tov = C_Tov
from Reserved
order by count(*) over (partition by C_Obj, C_Tov) desc

declare @Delta money=0.1
declare cursor1 cursor local fast_forward for 
select RecID, Kol_vo from Reserved  where C_Obj=@C_Obj and C_Tov=@C_Tov order by RecID DESC, D_Reg DESC, N_Reg DESC
open cursor1
declare @RecID int, @Kol_vo money, @Buf money
fetch next from cursor1 into @RecID, @Kol_vo
while (@@FETCH_STATUS = 0) and (@Delta>0)
begin
	set @Kol_vo = @Kol_vo-@Delta
	if @Kol_vo>0.0005 --AI_DELTA
	begin
		update Reserved 
		set Kol_vo=@Kol_vo
		output 'upd' oper, inserted.*, deleted.*
		where RecID=@RecID
		
		set @Delta = 0
	end
	else begin
		delete from Reserved 
		output 'del' oper, deleted.*
		where RecID=@RecID
		
		set @Delta = -@Kol_vo
	end
	fetch next from cursor1 into @RecID, @Kol_vo
end
close cursor1 
deallocate cursor1

/****** Object:  Table [dbo].[Reserved]    Script Date: 19.04.2018 22:06:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Reserved](
	[RecID] [int] IDENTITY(1,1) NOT NULL,
	[C_Obj] [smallint] NULL,
	[C_Tov] [int] NULL,
	[D_Reg] [datetime] NULL,
	[N_Reg] [smallint] NULL,
	[Kol_vo] [float] NULL,
 CONSTRAINT [PK_Reserved] PRIMARY KEY CLUSTERED 
(
	[RecID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Reserved]  WITH CHECK ADD  CONSTRAINT [CK_Reserved] CHECK  (([Kol_vo]>=(0)))
GO

ALTER TABLE [dbo].[Reserved] CHECK CONSTRAINT [CK_Reserved]
GO

/****** Object:  Index [Ind_C_Tov_C_Obj]    Script Date: 19.04.2018 22:13:53 ******/
CREATE NONCLUSTERED INDEX [Ind_C_Tov_C_Obj] ON [dbo].[Reserveds]
(
	[C_Tov] ASC,
	[C_Obj] ASC
)
INCLUDE ( 	[D_Reg],
	[N_Reg],
	[Kol_vo],
	[RecID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [Ind_D_Reg_N_Reg]    Script Date: 19.04.2018 22:15:50 ******/
CREATE NONCLUSTERED INDEX [Ind_D_Reg_N_Reg] ON [dbo].[Reserved]
(
	[D_Reg] ASC,
	[N_Reg] ASC
)
INCLUDE ( 	[RecID],
	[C_Obj],
	[C_Tov],
	[Kol_vo]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO