Prenos prometa na novu blagajnu

declare @i int

set @i = (select max(rb) as rb
from rGlava
where blagajna = '3330')

if object_id('tempdb..#t') is not null
drop table #t

select kljuc, '18-3330-'+ ltrim(rtrim(str(rb+@i,6))) as KljucNew
into #t
from rGlava
where blagajna = '3300'

update g
set g.kljuc = t.kljucnew, g.rb = g.rb + @i, g.blagajna = '3330'
from rGlava g
inner join #t t on g.kljuc = t.kljuc

update g
set g.kljuc = t.kljucnew
from rGlavaBlg g
inner join #t t on g.kljuc = t.kljuc

update g
set g.kljuc = t.kljucnew
from tPozicije g
inner join #t t on g.kljuc = t.kljuc