declare @rez table (UNSMZ int, kol_p decimal(14,5), rownumb int, KMAT varchar(15), kol_f decimal(14,5), nop varchar(7), kttop varchar(4)
                    , mktskol_f decimal(14,5), code128 varchar(50), unsmzp int, kol_i decimal(14,5), mkn int
                        , HEIGHT int, LENGHT int, WIDTH int, EDI int, RCENTR_P varchar(10), NTTOP_F varchar(200)
                            , SNEDI varchar(20), kzbr varchar(5), nedimt varchar(200), matQt decimal(16,4), MktComm varchar(200)
				, matherial varchar(200), KmatMat varchar(15), OstMat decimal(16,4), Kmat_Mat varchar(15), OstMatPod decimal(16,4))
									             
insert into @rez (UNSMZ, kol_p,rownumb, kmat, kol_f, nop, kttop, mktskol_f, code128, unsmzp, kol_i, mkn, height, lenght, width, edi, rcentr_p, nttop_f,snedi, kzbr
                    , nedimt, matQt, MktComm, matherial, KmatMat, OstMat, Kmat_Mat, OstMatPod)              
                    
                select t.UNSMZ, t.kol_p, t.rownumb, t.KMAT, t.kol_f, t.nop, t.kttop, t.mktskol_f, t.code128, t.unsmzp, t.kol_i, t.mkn ,
                    k.HEIGHT, k.LENGHT, k.WIDTH, mkt.EDI, smz.RCENTR_P, ttop.NTTOP as NTTOP_F, d.SNEDI, p.kzbr
                    , cast('' as varchar(50)) as nedimt
                    , cast(0 as numeric(10,2)) as matQt
                    , isnull(
                            (select top 1 z.ZAGOTOVKA 
                            from _ZAGOT z 
                            where z.kmat=MKT.kmat and z.NTECHPR=MKT.NTECHPR),'') as MktComm
                    , cast('' as varchar(200)) as matherial
                    , cast('' as varchar(15)) as KmatMat 
                    , cast(0 as numeric(10,1)) as OstMat
                    , cast('' as varchar(15)) as Kmat_Mat 
                    , cast(0 as numeric(10,1)) as OstMatPod
                from t
                left join smz 
                    on smz.unsmz=t.unsmz
                left join mkts 
                    on mkts.unmkts=smz.unmkts
                left join mkt 
                    on mkt.unmkt=mkts.unmkt
                left join ksm k 
                    on k.kmat=t.kmat
                left join ttop 
                    on ttop.kttop=t.kttop
                left join tapei d 
                    on d.edi=mkt.edi
                left join smzp p
                    on smz.unsmzp = p.unsmzp
                left join zbr
                    on p.kzbr = zbr.kzbr and p.ceh = zbr.ceh and zbr.PR_DO <> 'О'

                         --delete from @rez
                -- where not kzbr in ('00002', '00006', '00027', '00037')