I also encountered this problem and solved it using an inline view:

DECLARE @SKIPROWS INT

SET @SKIPROWS = 4 --SKIP THE FIRST 4 ROWS

SELECT * FROM(

SELECT

ROW_NUMBER () OVER (ORDER BY (SELECT 1...