Untitled

 avatar
unknown
plain_text
a year ago
904 B
1
Indexable
DROP TABLE IF EXISTS #KP_CommonClientsOkved_KP; -- подтягиваем оквэды к таблице с клиентами, которые есть и у нас, и у дилеров
SELECT 
	ccl.transaction_date,
	ccl.agent_inn_dil, 
	ccl.client_inn_dil, 
	ccl.client_name_dil,
	SUM(ccl.monthly_litres_dil) AS total_monthly_litres_dil,
	SUM(ccl.client_name_GZPN) AS total_monthly_litres_GZPN,
	ccl.monthly_litres_GZPN,
	okved.[ИНДЕКС]

INTO #KP_CommonClientsOkved_KP
FROM #CommonClients_KP ccl
LEFT JOIN [SANDBOX_DB_TEAM_21].[dbo].[Med_Okved] okved 
	ON ccl.client_inn_dil=okved.[ИНН]
GROUP BY 
	ccl.agent_inn_dil,
	ccl.client_inn_dil, 
	ccl.client_name_dil, 
	ccl.client_name_GZPN, 
	okved.[ИНДЕКС],
	transaction_date,
	monthly_litres_dil,
	monthly_litres_GZPN


Msg 8117, Level 16, State 1, Line 273
Operand data type nvarchar is invalid for sum operator.
Leave a Comment