Correct synapse sql to get data from TABLES DCEBSSCELLADJRAW01,..., DCEBSSCELLADJRAW15…
- User
Correct synapse sql to get data from TABLES DC_E_BSS_CELL_ADJ_RAW_01,..., DC_E_BSS_CELL_ADJ_RAW_15
SELECT BSC as [BSC_Name], DDATE_ID, CELL_NAME_NEIGHBOUR as [Neighbour_Cell_Name], CELL_NAME as [Cell_Name], SUM(HOVERCNT) as [2G Attempts_for_14_Days] FROM DC.DC_E_BSS_CELL_ADJ_RAW WHERE DATE_ID >= DATEADD(DAY,-14,GETDATE()) GROUP BY BSC, CELL_NAME, CELL_NAME_NEIGHBOUR; - Assistant
To get data from tables DC_E_BSS_CELL_ADJ_RAW_01 to DC_E_BSS_CELL_ADJ_RAW_15, you can use the UNION ALL operator in your SQL query. Here is the corrected synapse sql:
SELECT BSC as [BSC_Name], DDATE_ID, CELL_NAME_NEIGHBOUR as [Neighbour_Cell_Name], CELL_NAME as [Cell_Name], SUM(HOVERCNT) as [2G Attempts_for_14_Days] FROM ( SELECT BSC, DDATE_ID, CELL_NAME_NEIGHBOUR, CELL_NAME, HOVERCNT FROM DC.DC_E_BSS_CELL_ADJ_RAW_01 UNION ALL SELECT BSC, DDATE_ID, CELL_NAME_NEIGHBOUR, CELL_NAME, HOVERCNT FROM DC.DC_E_BSS_CELL_ADJ_RAW_02 UNION ALL ... SELECT BSC, DDATE_ID, CELL_NAME_NEIGHBOUR, CELL_NAME, HOVERCNT FROM DC.DC_E_BSS_CELL_ADJ_RAW_15 ) as RAW_DATA WHERE DDATE_ID >= DATEADD(DAY,-14,GETDATE()) GROUP BY BSC, CELL_NAME, CELL_NAME_NEIGHBOUR;This query uses the UNION ALL operator to combine the results from each table into a single result set. The WHERE clause filters the data based on the DATE_ID, and the GROUP BY clause aggregates the data based on the specified columns.