Добавить в запрос столбец

 DECLARE @DATE DATETIME = '01.12.2022 ' 
  DECLARE @MONTH INT = MONTH(@DATE) 
 DECLARE @YEAR INT = YEAR(@DATE) 
 ------------------------------------- 
 SELECT DISTINCT  ku, km,np,datan,datak,date_record,fio_tex,modler,hud,mast,stt, ltrim ([otv]) AS otv,dp, prov,isrok,mod_now,mod_noww,TABN ,vozv,vid FROM
 (SELECT DISTINCT ku,CAST(km AS INT) AS km,np,datan,datak,date_record,fio_tex,modler,hud,mast
  ,CASE WHEN stt IS NULL THEN 0 ELSE stt END AS stt,rtrim ([otv]) AS otv,dp,rtrim (prov) AS prov,isrok,mod_now  
  ,CASE WHEN mod_now<>0 THEN '*' ELSE ' ' END AS mod_noww ,CASE WHEN vozv=1 THEN 'возврат' ELSE ' ' END AS vozv,vid FROM  
 ------------------------------------- 
 (SELECT DISTINCT pm.kp,pm.ku AS ku,km,np,pm.datan AS datan,datak,date_record,FAN AS fio_tex 
 ,[Designer_Id],[Painter_Id], d1.Worker_Full_Name AS modler, d2.Worker_Full_Name AS hud 
,SPMAS.fam AS mast,stt,SUBSTRING(avt.[otv] , 1, (len(avt.[otv] ) - 1)) AS otv  
,dp --,convert(char(10), dp, 104) as dp 
  ,prov 
,CONVERT(CHAR(10), isrok, 104) AS isrok    
 ,CASE WHEN mod_now IS NULL THEN 0 ELSE mod_now END AS mod_now,vozv,vid  FROM  
 ------------------------------------- 
  (SELECT DISTINCT * FROM [1201].[dbo].[Plane_PM] WHERE date_record= @DATE) AS pm 
 ------------------------------------- 
  LEFT OUTER JOIN [NSI].[dbo].[SprMod] sprmod ON sprmod.M = pm.km 
  LEFT OUTER JOIN (SELECT DISTINCT * FROM[NSI].[dbo].[NSIFP] ) AS NSIFP ON NSIFP.KY = pm.ku     
  LEFT OUTER JOIN [NSI].[dbo].[SprInfoModel] ON pm.km= SprInfoModel.Model_ID  
 LEFT OUTER JOIN [NSI].[dbo].[SPRWORKER_NAME] AS d1 ON d1.Worker_ID= SprInfoModel.Designer_Id  
  LEFT OUTER JOIN [CRB].[dbo].[SPRABOB] AS G1 ON d1.Worker_Full_Name= G1.FIO 
 LEFT OUTER JOIN [NSI].[dbo].[SPRWORKER_NAME] AS d2 ON d2.Worker_ID= SprInfoModel.Painter_Id  
 LEFT OUTER JOIN (SELECT DISTINCT KY,FAM FROM NSI.dbo.SPMAS WHERE KY <> 0 AND KY<>102 AND KY<>902  ) AS SPMAS ON SPMAS.ky = pm.ku 
  LEFT OUTER JOIN(SELECT DISTINCT MOD,ku,MAX(STATUS) AS stt,MAX(srok) AS dp FROM [IPK].[dbo].[AVT_NADZ] WHERE MONTH(datan)=@MONTH AND YEAR(datan)= @YEAR GROUP BY MOD,ku )   
AS AVT1 ON AVT1.mod = pm.km AND AVT1.ku = pm.ku
LEFT OUTER JOIN(SELECT DISTINCT MOD,prov,srok,vozv,vid FROM [IPK].[dbo].[AVT_NADZ] WHERE MONTH(datan)=@MONTH AND YEAR(datan)= @YEAR) AS AVT2 ON AVT2.mod = pm.km AND AVT2.srok=dp  
  LEFT OUTER JOIN (  SELECT DISTINCT MOD,ku,isrok AS sr,datan,srok, (SELECT otv + ',' AS [text()]FROM [IPK].[dbo].[AVT_NADZ] ST1 WHERE ST1.mod = ST2.mod 
 AND MONTH(datan)=@MONTH AND YEAR(datan)= @YEAR   
 ORDER BY ST1.mod FOR XML PATH ('')) otv FROM [IPK].[dbo].[AVT_NADZ] ST2 WHERE MONTH(datan)=@MONTH AND YEAR(datan)= @YEAR)AS AVT ON AVT.mod = pm.km AND AVT.ku = pm.ku   
LEFT OUTER JOIN(SELECT DISTINCT MOD,ku,MAX(isrok) AS isrok  FROM [IPK].[dbo].[AVT_NADZ] WHERE MONTH(datan)=@MONTH AND YEAR(datan)= @YEAR  GROUP BY MOD,ku ) AS AVT3 ON AVT3.mod = pm.km AND AVT3.ku = pm.ku 
LEFT OUTER JOIN(SELECT DISTINCT Model_ID  AS mod_now FROM [NSI].[dbo].[SprInfoModel] WHERE Date_Starting =@DATE AND Model_ID <>' '  ) AS now_mod ON now_mod.mod_now = pm.km   
 ) AS it ) AS it2   
 LEFT OUTER JOIN [CRB].[dbo].[SPRABOB] AS G2 ON it2.prov= G2.FIO      
  -- where km=2718 
 ORDER BY ku,km,datan