Result_page da oracle a sql server

select *
      from ( select /*+ FIRST_ROWS(n) */
      a.*, ROWNUM rnum
      from
      (
      SELECT /*+ index (A INDX_TRASM3) */
      ROW_NUMBER() OVER(ORDER BY a.dta_invio DESC) AS RN,
      a.system_id,
      a.id_ruolo_in_uo as ruolo_system_id,
      g.var_cod_rubrica as ruolo_mittente,
      a.id_people as user_system_id,
      p.full_name as user_id,
      a.cha_tipo_oggetto,
      a.id_profile,
      a.id_project,
      dta_invio,
      a.var_note_generali,
      a.cha_salvata_con_cessione,
      g.VAR_DESC_CORR as ruolo,
      p.user_id as us_id,
      a.id_people_delegato
      FROM      dpa_trasmissione a
      INNER JOIN dpa_trasm_singola ts on a.system_id = ts.id_trasmissione 
      INNER JOIN dpa_trasm_utente tu ON ts.system_id = tu.id_trasm_singola
      INNER JOIN people p ON a.id_people = p.system_id
      INNER JOIN dpa_corr_globali g ON a.id_ruolo_in_uo = g.system_id
      WHERE     filters
      ) a
      where ROWNUM <= endRow )
  where rnum  >= startRow;

CREATE PROCEDURE Risultato_Page_New_Rowcount
(
   @startRowIndex int,
   @maximumRows int
)
AS
 
DECLARE @TempItems TABLE
(
   ID int IDENTITY,
   EmployeeID int
)
 
DECLARE @maxRow int


SET @maxRow = (@startRowIndex + @maximumRows) - 1 

SET ROWCOUNT @maxRow

INSERT INTO @TempItems (EmployeeID)
SELECT EmployeeID
FROM Employees
ORDER BY EmployeeID

SET ROWCOUNT @maximumRows

SELECT /*+ index (A INDX_TRASM3) */
      ROW_NUMBER() OVER(ORDER BY a.dta_invio DESC) AS RN,
      a.system_id,
      a.id_ruolo_in_uo as ruolo_system_id,
      g.var_cod_rubrica as ruolo_mittente,
      a.id_people as user_system_id,
      p.full_name as user_id,
      a.cha_tipo_oggetto,
      a.id_profile,
      a.id_project,
      dta_invio,
      a.var_note_generali,
      a.cha_salvata_con_cessione,
      g.VAR_DESC_CORR as ruolo,
      p.user_id as us_id,
      a.id_people_delegato
      FROM      dpa_trasmissione a
      INNER JOIN dpa_trasm_singola ts on a.system_id = ts.id_trasmissione 
      INNER JOIN dpa_trasm_utente tu ON ts.system_id = tu.id_trasm_singola
      INNER JOIN people p ON a.id_people = p.system_id
      INNER JOIN dpa_corr_globali g ON a.id_ruolo_in_uo = g.system_id
WHERE ID >= @startRowIndex

SET ROWCOUNT 0

GO

select a.*, RN rnum
      from
      (
      SELECT 
      ROW_NUMBER() OVER(ORDER BY a.dta_invio DESC) AS RN,
      a.system_id,
      a.id_ruolo_in_uo as ruolo_system_id,
      g.var_cod_rubrica as ruolo_mittente,
      a.id_people as user_system_id,
      p.full_name as user_id,
      a.cha_tipo_oggetto,
      a.id_profile,
      a.id_project,
      dta_invio,
      a.var_note_generali,
      a.cha_salvata_con_cessione,
      g.VAR_DESC_CORR as ruolo,
      p.user_id as us_id,
      a.id_people_delegato
      FROM      dpa_trasmissione a
      INNER JOIN dpa_trasm_singola ts on a.system_id = ts.id_trasmissione 
      INNER JOIN dpa_trasm_utente tu ON ts.system_id = tu.id_trasm_singola
      INNER JOIN people p ON a.id_people = p.system_id
      INNER JOIN dpa_corr_globali g ON a.id_ruolo_in_uo = g.system_id
      WHERE   /*  filters*/
      ) a
      where RN between startRow and endRow

select a.*, RN rnum
      from
      (
      SELECT 
      ROW_NUMBER() OVER(ORDER BY a.dta_invio DESC) AS RN,
      a.system_id,
      a.id_ruolo_in_uo as ruolo_system_id,
      g.var_cod_rubrica as ruolo_mittente,
      a.id_people as user_system_id,
      p.full_name as user_id,
      a.cha_tipo_oggetto,
      a.id_profile,
      a.id_project,
      dta_invio,
      a.var_note_generali,
      a.cha_salvata_con_cessione,
      g.VAR_DESC_CORR as ruolo,
      p.user_id as us_id,
      a.id_people_delegato
      FROM      dpa_trasmissione a
      INNER JOIN dpa_trasm_singola ts on a.system_id = ts.id_trasmissione 
      INNER JOIN dpa_trasm_utente tu ON ts.system_id = tu.id_trasm_singola
      INNER JOIN people p ON a.id_people = p.system_id
      INNER JOIN dpa_corr_globali g ON a.id_ruolo_in_uo = g.system_id
      -- WHERE   /*  filters*/
      ) a
      where RN between startRow and endRow