Brisanje POS prometa iz ranijih godina

create database POSpromet
go

use POSpromet
go

select * into rGlava from Baza55.dbo.rGlava 
select * into rGlavaBlg from Baza55.dbo.rGlavaBlg
select * into rPozicije from Baza55.dbo.rPozicije

--

select * into rGlavaSUM from Baza55.dbo.rGlavaSum
select * into rPozicijeSUM from Baza55.dbo.rPozicijeSum

--

use Baza55
go

delete rGlava where kljuc not like '19%'
go

delete rGlavaBlg where kljuc not like '19%'
go

delete rPozicije where kljuc not like '19%'
go

delete rGlavaSUM where kljuc not like '19%'
go

delete rPozicijeSUM where kljuc not like '19%'
go