Allocations Check, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

create table Allocations(
     Id int identity(1,1) not null primary key,
    BankRefr int,
    BankType varchar(2),
    BankAlloc money,
    YearNo int,
    Period int,
    Nomcode varchar(10),
    Allocated money
)
go
Create procedure ReconcileCreditorPayments(
  @YearNo int,
  @Period int
)
As
Begin
  Create table #RecTable(
    LineType tinyint,
    BankRefr int,
    BankType varchar(2),
    LineDesc varchar(100),
    Nominal varchar(10),
    Amount money
  )

/* Add payments */
  insert into #RecTable(LineType, BankRefr, BankType, LineDesc, Nominal, Amount)
  select distinct 1, BankRefr, BankType, 'Payment', '', Abs(BankAlloc)
  from Allocations
  where YearNo = @YearNo and Period = @Period;
  
  /* Add lines */
  insert into #RecTable(LineType, BankRefr, BankType, LineDesc, Nominal, Amount)
  select 2, BankRefr, BankType, '', Nomcode, abs(sum(Allocated))
  from Allocations
  where YearNo = @YearNo and Period = @Period
  group by BankRefr, BankType, Nomcode;
  
  /* Add variance lines */
  insert into #RecTable(LineType, BankRefr, BankType, LineDesc, Nominal, Amount)
  select 3, BankRefr, BankType, 'Variance', '', sum(case LineType when 1 then Amount else -Amount end)
  from #RecTable
  group by BankRefr, BankType;
  
  select BankRefr, BankType, LineDesc, Nominal, Amount
  from #RecTable
  order by BankType, BankRefr, LineType;
  
  drop table #RecTable;

End
go
insert into Allocations(BankRefr, BankType, BankAlloc, YearNo, Period, Nomcode, Allocated)
select 1, 'PY', 100, 1, 1, '1000', -50
UNION
select 1, 'PY', 100, 1, 1, '2000', -40
union
select 2, 'PY', 100, 1, 1, '1000', 50
UNION
select 2, 'PY', 100, 1, 1, '2000', 50;
go

Exec ReconcileCreditorPayments 1, 1

View schema
Execution time: 0,03 sec, rows selected: 8, rows affected: 12, absolute service time: 0,2 sec