hi there,,, unfortunetly I fight with similer problem ;P
,sum(data_table_uplink) as total_data_table_uplink
,sum(data_table_downlink) as total_data_table_downlink
,sum(data_table_UPLINK) as total_data_table__UPLINK
,sum(data_table_DOWNLINK) as total_data_table__DOWNLINK
,sum(data_table__DURATION) as total_data_table__DURATION
group by 1,2,3,4,5,6
It is a part of bigger select but this part returns me Select Failed. 2616: Numeric overflow occured during computation.
Any sugestions? ;/
check the data types of
It looks like the sums are exceding the maximum values for at least one of the colums.
Lets assume they are integers
in this case
,sum(cast(data_table_uplink as decimal(18,0))) as total_data_table_uplink
,sum(cast(data_table_downlink as decimal(18,0))) as total_data_table_downlink
,sum(cast(data_table_UPLINK as decimal(18,0))) as total_data_table__UPLINK
,sum(cast(data_table_DOWNLINK as decimal(18,0))) as total_data_table__DOWNLINK
,sum(cast(data_table__DURATION as decimal(18,0))) as total_data_table__DURATION
is likely to work.