I reduced my poor performing query from 10 min to 2 now if I could only use it

Question

I reduced my poor performing query from 10 min to 2 now if I could only use it

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Jim McLeod SSCarpal Tunnel Points: 4057 More actions · Answer 1

The OVER SQL Construct or statment is not supported.
Ok so reporting services can not deal with the ROW_NUMBER function no big deal I will just place the query in a SP and call that.

You can receive a similar error when writing a query in SSAS. I haven't checked Reporting Services, but it's probably the same dialog box. The query designer cannot handle the OVER clause, so in the dialog box where you can paste your SQL, try turning off everything except the SQL pane.