CODEWITHSUNDEEP
sql-server-2008visual-studio-2008dense-rank
Caroline Allen
Caroline Allen

Reputation: 173

DENSE_RANK() OVER (ORDER BY ....) not supported by Visual Studio 2008

I have the following in my SQL:

SELECT   
    DENSE_RANK() OVER (ORDER BY i.invoicenumber) AS Reference

This runs fine in SQL Server Management Studio but is not supported by Microsoft Visual Studio 2008.

I get the following SQL syntax error:

The OVER SQL construct or statement is not supported

Is there something else that I can use that will do the same job and will work in Visual Studio 2008?

Many thanks

Upvotes: 0

Views: 164

Answers (2)

Khornight
Khornight

Reputation: 53

Did you try running it? I get the same error message from visual studio, but it still returns what I'm looking for.

(this isn't really an answer, but I don't have enough rep to post a comment!)

Upvotes: 1

usr
usr

Reputation: 171206

Visual Studio has no idea what the SQL means that you execute. It just sends it to the server. You are connected to a server that does not support this syntax.

Upvotes: 0

Related Questions