Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· openaiHugging Face Suzhen/CodeChat

Correct synapse sql to get data from TABLES DCEBSSCELLADJRAW01,..., DCEBSSCELLADJRAW15…

  1. 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;

  2. 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.