declare @dateN  date = '2020-07-01'
declare  @datek date = '2020-07-31'

 select  r.*
, 1 pr_str
,case when  isnull((select  dd.kol
				from dms dd
				where dd.undoc	=r.UNDOC and dd.npp=r.NPP
						and dd.KDMT='СБП'
				),1) >0 
		then 0
		else 1									
	end flgDopBraka
	, DATEPART(week, r.DDM) w
	, DATEPART(MONTH, r.DDM) m
	, DATEPART(YEAR, r.DDM) y
	--узнаем номер недели и года прошлой недели
	, DATEPART(week, DATEADD(week,-1,getdate())) lw  
	, DATEPART(YEAR, DATEADD(week,-1,getdate())) lwy
from(
select bb.FIO_D
	, bb.COMM, bb.DDM, bb.dprt, bb.FIO_OTV, bb.HSDOC, bb.KMAT, bb.KOL
	, bb.kom, bb.KPRT_DB, bb.N_RES_DOC, bb.NDM, bb.NDMT_S, bb.NPP
	, isnull(bb.per,0) per
	, bb.PR_RZN, bb.PRCH
	, isnull(bb.resh,'') resh
	, bb.sum_d, bb.sum_i, bb.UNDOC
    , bb.VID
    , '  '+isnull(bb.VID,'Вид брака не указан') VIDn                               
from _BRAKS_A bb
where bb.ddm between @dateN and @datek
    and not bb.KPRT_DB in ('Б00003/18','Б00007/18','Б00008/18','Б00010/18 ')
	and bb.vid <> 'Опытные работы' 
)r