Comments

3 comments

  • Official comment
    Avatar
    Sergey Smagin (Product manager)

    Hello, Tessa.

    Yes, windows functions are supported for MS SQL Server. Please check that you set the right syntax provider for your server:

    QueryBuilder.SyntaxProvider = new MSSQLSyntaxProvider();

    If you set it right but still receive a parsing error, please submit a support ticket. We will investigate this issue shortly.

    Comment actions Permalink
  • Avatar
    Tessa Smithers

    Hi Sergey,

    Thank you so much for the response. If this is out of scope of AQB support, please let me know, but does the statement above mean that we need to declare the Windows function first somehow before using OVER?

     

    Thanks!

    Tessa

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    Probably my mention of window functions wasn't correct. Sorry for this.

    Select queries for MS SQL Server with the OVER clause must be parsed fine in all the cases according to the documentation referred in your post.
    If you have a sample of a query which complies with this doc and AQB fails to parse it, please let me know.

    0
    Comment actions Permalink

Please sign in to leave a comment.