Github user mattyb149 commented on the issue: https://github.com/apache/nifi/pull/1510 Related to the discussion above, I am using SQL Server 2000 with GenerateTableFetch and am getting errors with the generated SQL. GTF does pagination, so it skips the "TOP" logic above and generates something like the following: `SELECT * FROM t1 ORDER BY id OFFSET 2 ROWS FETCH NEXT 2 ROWS ONLY` Which does not work. With respect to the new keywords in MSSQL 2012, I would think either this adapter should require 2012 (updating the name, description, and leverage the new commands), or use the aforementioned (yet awkward like Oracle's) query for offset/limit/pagination to support more users. Thoughts?
--- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---