Prelazak u novu godinu

na verzijama 2.0.269 do 2.0.271 greska pri kreiranju prvog novog racuna .

set nocount on

declare @nesto char (4)
declare xPoz cursor local fast_forward for
select blagajna from rGlava group by blagajna
open xPoz
fetch from xPoz into @nesto
while @@fetch_status = 0
begin
delete rGlava where kljuc = '19-'+@nesto+'-1'
delete rPozicije where kljuc = '19-'+@nesto+'-1'

insert into rGlava (kljuc, godina, blagajna, rb, datum, mpv, korisnik, nacinplacanja, napomena, kupac, pdv, osnova, nato, pot, syn, b, s, acFiskNo, Tip, Bod, Isporuka)
values('19-'+@nesto+'-1', '19', @nesto, 1, '2019-01-01', 0, 'a', 'Gotovina', '', 'Anonimni kupac', 0, 0, 'F', 'T', 'F', 0, 0, '', 0, 0, '')

insert into rPozicije (kljuc, poz, ident, naziv, kolicina, mpc, rabat, mpv, rmpc, s, realmpc, actarst)
values ('19-'+@nesto+'-1',1, '', '', 0, 0, 0, 0, 0, 0, 0, 'DV')

fetch from xPoz into @nesto
end
close xPoz
deallocate xPoz