An error occurred while reading data from the query result set.
Arithmetic overflow error converting expression to data type int.

select tt.*,
	--Общий эфект по мощности от СДЭМ
	isnull(sdem_power_sell_eff_cost,  0 ) + isnull(sdem_power_buy_eff_cost,  0 ) - exchange_fee_cost as sdem_power_eff_cost,
	isnull(sdem_power_sell_eff_cost_mod,  0 ) + isnull(sdem_power_buy_eff_cost_mod,  0 ) - exchange_fee_cost as sdem_power_eff_cost_mod,
	isnull(sdem_power_sell_vol,  0 )-isnull(sdem_power_buy_vol,  0 ) as sd_power_vol,
	isnull(sdem_power_sell_cost,  0 )-isnull(sdem_power_buy_cost,  0 ) as sd_power_cost,
	isnull(sdem_power_sell_cost_mod,  0 )-isnull(sdem_power_buy_cost_mod,  0 ) as sd_power_cost_mod,
	(isnull(sdem_power_sell_vol,  0 )-isnull(sdem_power_buy_vol,  0 ))*Tm*k_season	as cost_for_TmKsz
from
	(select t.*,
		--Эфект от продажи по СДЭМ
		sdem_power_sell_vol+sdem_execess_zsp_sell_kom_vol-buy_kom_gen_vol as direct_sdem_sell_deals_vol,
		sdem_power_sell_cost+sdem_execess_zsp_sell_kom_cost-buy_kom_gen_cost as direct_sdem_sell_deals_cost,
		sdem_power_sell_cost_mod+sdem_execess_zsp_sell_kom_cost_mod-buy_kom_gen_cost_mod as direct_sdem_sell_deals_cost_mod,
		(sdem_power_sell_cost + sdem_execess_zsp_sell_kom_cost - buy_kom_gen_cost)
		- sdem_power_sell_eff_vol * Tm * k_season as sdem_power_sell_eff_cost,
		(sdem_power_sell_cost_mod+sdem_execess_zsp_sell_kom_cost_mod-buy_kom_gen_cost_mod)
		- sdem_power_sell_eff_vol * Tm as sdem_power_sell_eff_cost_mod,
		--Эфект от покупки по СДЭМ
		case when sdem_power_buy_vol > buy_fact_cons_vol
			then (sdem_power_buy_vol - buy_fact_cons_vol)* Tm_kom_init
			else (sdem_power_buy_vol - buy_fact_cons_vol)* Tm_kom_end
		end - sdem_power_buy_cost - buy_fact_cons_vol * Tm_kom_end as sdem_power_buy_eff_cost,
		case when sdem_power_buy_vol > buy_fact_cons_vol
			then (sdem_power_buy_vol - buy_fact_cons_vol)* Tm_kom_init/k_season
			else (sdem_power_buy_vol - buy_fact_cons_vol)* Tm_kom_end/k_season
		end - sdem_power_buy_cost_mod - buy_fact_cons_vol * Tm_kom_end/k_season as sdem_power_buy_eff_cost_mod
	from
		(select 
			cg.y,
			cg.m,
			cg.id_gres,
			i.k_season,
			i.Tm_kom_init,
			i.Tm_kom_end,
			gm.Tm,
			
			sds.sdem_power_sell_vol, -- продажа мощности по СДЭМ
			sds.sdem_power_sell_cost,
			sds.sdem_power_sell_cost_mod,
			
			sdb.sdem_power_buy_vol, -- покупка мощности по СДЭМ
			sdb.sdem_power_buy_cost,
			sdb.sdem_power_buy_cost_mod,

			cg.buy_kom_gen_vol, -- покупка у ЦФР превышения лимитов (физических и перетоков в ЗСП) по итог. цене КОМ
			cg.buy_kom_gen_vol*i.Tm_kom_end as buy_kom_gen_cost,
			cg.buy_kom_gen_vol*i.Tm_kom_end/i.k_season as buy_kom_gen_cost_mod,
			
			cg.gr_sum_excess_vol as sdem_execess_zsp_sell_kom_vol, -- продажа превышения лимита перетока в другие ЗСП ЦФРу
			cg.gr_sum_excess_vol*gm.Tm*i.k_season as sdem_execess_zsp_sell_kom_cost,
			cg.gr_sum_excess_vol*gm.Tm as sdem_execess_zsp_sell_kom_cost_mod,

			case when cg.Nfree_vol<sds.sdem_power_sell_vol
				then cg.Nfree_vol
				else sds.sdem_power_sell_vol
			end as sdem_power_sell_eff_vol,
			
			isnull(cc.buy_fact_cons_vol,  0 ) as buy_fact_cons_vol, -- покупка потребления
			isnull(ef.exchange_fee_cost,  0 ) as exchange_fee_cost -- комиссия биржи
			

		from [qv_capacity_kom_gen] cg
		join (select distinct id_gres, price_zone from tbl_gtp) gt on gt.id_gres=cg.id_gres
		join dbo.tbl_imbalance i
			on i.price_zone=gt.price_zone and i.[year]=cg.y and i.[month]=cg.m 
		join tbl_GRES_monthly gm
			on gm.id_gres=cg.id_gres and cg.y=gm.[year] and cg.m=gm.[month_num]
		left join
				(select sm.y, sm.m, gt.id_gres,
				sum(isnull(sm.power_vol, s.power_vol)) as sdem_power_sell_vol,
				sum(round(case when s.use_kses= 1  then isnull(sm.power_price, s.power_price)*i.k_season else isnull(sm.power_price, s.power_price) end 
					* isnull(sm.power_vol, s.power_vol),  2 )) as sdem_power_sell_cost,
				sum(round(case when s.use_kses= 0  then isnull(sm.power_price, s.power_price)/i.k_season else isnull(sm.power_price, s.power_price) end 
					* isnull(sm.power_vol, s.power_vol),  2 )) as sdem_power_sell_cost_mod
				from dbo.tbl_dd_price s join dbo.tbl_sdem_month sm on s.dd_kod=sm.dd_kod
				join tbl_gtp gt on gt.gtp_name=s.gtp_name
				join dbo.tbl_imbalance i
					on i.price_zone=gt.price_zone and i.[year]=sm.y and i.[month]=sm.m 

				where s.[role]='Продавец'
				group by sm.y, sm.m, gt.id_gres) sds
		on sds.y=cg.y and  sds.m=cg.m and sds.id_gres=cg.id_gres
		left join
				(select sm.y, sm.m, gt.id_gres,
				sum(isnull(sm.power_vol, s.power_vol)) as sdem_power_buy_vol,
				--sum(isnull(sm.power_vol, s.power_vol)*isnull(sm.power_price, s.power_price)) as sdem_buy_cost
				sum(round(case when s.use_kses= 1  then isnull(sm.power_price, s.power_price)*i.k_season else isnull(sm.power_price, s.power_price) end 
					* isnull(sm.power_vol, s.power_vol),  2 )) as sdem_power_buy_cost,
				sum(round(case when s.use_kses= 0  then isnull(sm.power_price, s.power_price)/i.k_season else isnull(sm.power_price, s.power_price) end 
					* isnull(sm.power_vol, s.power_vol),  2 )) as sdem_power_buy_cost_mod

				from dbo.tbl_dd_price s join dbo.tbl_sdem_month sm on s.dd_kod=sm.dd_kod
				join tbl_gtp gt on gt.gtp_name=s.gtp_name
				join dbo.tbl_imbalance i
					on i.price_zone=gt.price_zone and i.[year]=sm.y and i.[month]=sm.m
				where s.[role]='Покупатель'
				group by sm.y, sm.m, gt.id_gres) sdb
			on sdb.y=cg.y and  sdb.m=cg.m and sdb.id_gres=cg.id_gres
		left join qv_capacity_kom_cons cc
			on cc.y=cg.y and  cc.m=cg.m and cc.id_gres=cg.id_gres
		left join
			(select t.y, t.m, g.id_gres,
				sum(exchange_fee_cost) as exchange_fee_cost
				from
				(select 
					cast(substring(contract_code,  5 , 2 ) as int)+ 2000  as  y, 
					cast(substring(contract_code,  8 , 2 ) as int) as m, 
					case when buy_sell=N'S' 
						then seller_gtp 
						else buyer_gtp
					end as gtp_name, 
					sum(contract_count * contract_price)/ 1000  as exchange_fee_cost
				from dbo.tbl_sdem_deals
				group by cast(substring(contract_code,  5 , 2 ) as int)+ 2000 , cast(substring(contract_code,  8 , 2 ) as int), case when buy_sell=N'S' then seller_gtp else buyer_gtp end
				) t join tbl_gtp g on t.gtp_name=g.gtp_name
				group by t.y, t.m, g.id_gres
				) ef
			on ef.y=cg.y and  ef.m=cg.m and ef.id_gres=cg.id_gres
		) t
	) tt