fiscalResponse

SpeedUp Table and Truncate

Step 1

select t.*
into #fr
from rGlava g
inner join fiscalResponse t on g.kljuc = t.acKey
where g.datum >= '2025-08-14';

truncate table fiscalResponse;

insert into fiscalResponse
select * from #fr;

Step 2

delete fiscalResponse where acKey is null;

ALTER TABLE fiscalResponse
ALTER COLUMN acKey CHAR(15) NOT NULL; 

ALTER TABLE fiscalResponse
ADD CONSTRAINT PK_fiscalResponse PRIMARY KEY (acKey);