SQL Prompt doesn't format OFFSET

nhaslam

Hi,
When formatting this (AdventureWorks2012) code:

SELECT ROW_NUMBER() OVER ( ORDER BY Name ) AS 'RowNumber', name, listprice
FROM Production.Product
ORDER BY Name
OFFSET 20 ROWS
FETCH NEXT 10 ROWS only

It formats it too
SELECT ROW_NUMBER() OVER ( ORDER BY Name ) AS 'RowNumber', name, listprice
FROM Production.Product
ORDER BY NameOFFSET 20 ROWS
FETCH NEXT 10 ROWS only

which is invalid (NameOFFSET should maintain the space)

This is on SQL Prompt 6.1.0.88.

Cheers

Nick

Anu D

Many thanks for your post.

Can you email us the SQL Prompt style you are using?

You can export your style as specified here

Please email this to support@red-gate.com with this forum link in it's subject.