How can we help you today? How can we help you today?

SQL Window functions cause error when formatting code

for example:
SELECT @LibraryID
, c.CategoryNameLTID
, ROW_NUMBER() OVER (ORDER BY ID) AS Row
, @UserID
, @DateTime
FROM BestPracticeLibrary.Categories AS c;

perfectly valid SQL, but SQL Prompt does not like it.
Ted Williamson
0

Comments

2 comments

Sort by
  • buckley
    No problem here with 7.1.0.306

    (Replaced the variables by constants though)

    SELECT
    1 ,
    c.CategoryNameLTID ,
    ROW_NUMBER() OVER (ORDER BY ID) AS Row ,
    2 ,
    3
    FROM
    BestPracticeLibrary.Categories AS c;
    buckley
    0
  • a_ted_w
    doh, I guess it does help to have to latest version. thnx
    a_ted_w
    0

Add comment

Please sign in to leave a comment.