Untitled
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