Spójrzcie proszę na kod poniżej, można coś zmienić, żeby było szybciej?
IF OBJECT_ID('[dbo].[b20_dane_ABC_rezer]') IS NOT NULL
DROP TABLE b20_dane_ABC_rezer
SELECT
RM_N_INDEX,
Sum(RM_DEF_TALCE_1) AS RM_DEF_TALCE_1,
Sum(RM_ETQ_PERP_1) AS RM_ETQ_PERP_1,
Sum(RM_DEF_TALCE_2) AS RM_DEF_TALCE_2,
Sum(RM_ETQ_PERP_2) AS RM_ETQ_PERP_2,
Sum(RM_DEF_TALCE_3) AS RM_DEF_TALCE_3,
Sum(RM_ETQ_PERP_3) AS RM_ETQ_PERP_3,
Sum(RM_DEF_TALCE_4) AS RM_DEF_TALCE_4,
Sum(RM_ETQ_PERP_4) AS RM_ETQ_PERP_4,
Sum(RM_DEF_TALCE_5) AS RM_DEF_TALCE_5,
Sum(RM_ETQ_PERP_5) AS RM_ETQ_PERP_5,
Sum(RM_DEF_TALCE_6) AS RM_DEF_TALCE_6,
Sum(RM_ETQ_PERP_6) AS RM_ETQ_PERP_6,
Sum(RM_DEF_TALCE_7) AS RM_DEF_TALCE_7,
Sum(RM_ETQ_PERP_7) AS RM_ETQ_PERP_7,
Sum(RM_DEF_TALCE_8) AS RM_DEF_TALCE_8,
Sum(RM_ETQ_PERP_8) AS RM_ETQ_PERP_8
INTO b20_dane_ABC_rezer
FROM OPENQUERY(REPLIKA_EU, 'SELECT
TABELA03.RESERV_ABC.RM_N_INDEX,
TABELA03.RESERV_ABC.RM_DEF_TALCE_1,
TABELA03.RESERV_ABC.RM_ETQ_PERP_1,
TABELA03.RESERV_ABC.RM_DEF_TALCE_2,
TABELA03.RESERV_ABC.RM_ETQ_PERP_2,
TABELA03.RESERV_ABC.RM_DEF_TALCE_3,
TABELA03.RESERV_ABC.RM_ETQ_PERP_3,
TABELA03.RESERV_ABC.RM_DEF_TALCE_4,
TABELA03.RESERV_ABC.RM_ETQ_PERP_4,
TABELA03.RESERV_ABC.RM_DEF_TALCE_5,
TABELA03.RESERV_ABC.RM_ETQ_PERP_5,
TABELA03.RESERV_ABC.RM_DEF_TALCE_6,
TABELA03.RESERV_ABC.RM_ETQ_PERP_6,
TABELA03.RESERV_ABC.RM_DEF_TALCE_7,
TABELA03.RESERV_ABC.RM_ETQ_PERP_7,
TABELA03.RESERV_ABC.RM_DEF_TALCE_8,
TABELA03.RESERV_ABC.RM_ETQ_PERP_8
FROM TABELA03.RESERV_ABC')
JOIN [listing].[dbo].[b20_dane_ABC_daty]
ON RM_N_INDEX = [listing].[dbo].[b20_dane_ABC_daty].EM_N_INDEX
WHERE DATA_START < getdate() AND DATA_END <=getdate()