Post reply

problem in ssrs expression

  • June 18, 2012 at 4:02 am

    This was removed by the editor as SPAM

  • June 18, 2012 at 4:03 am

    #1502151

    You have not yet replied. Paste the SQL and the sample data you are using.

    Raunak J

  • June 18, 2012 at 4:08 am

    #1502153

    i now try used this code and result was good

    select Score, DENSE_RANK() OVER ( order by Score desc) AS Ranking

    FROM cuscore

    ORDER BY Ranking

    but i dont know why below error accured

    The OVER SQL construct or statement is not supported.

  • June 18, 2012 at 4:16 am

    This was removed by the editor as SPAM

  • June 18, 2012 at 4:16 am

    #1502156

    Write this code in a stored procedure and then call the procedure. Also, what version of SQL Server are you using. Also, is this error result appearing in the SSMS?

    Run this query in SSMS and reply your observations.

    Raunak J

  • June 18, 2012 at 4:19 am

    #1502157

    now i use this code in SQL Server Business Intelligence in sql2008R2

  • June 18, 2012 at 4:23 am

    #1502159

    Can you call the procedure in SQL Server Management Studio without any error?

    Raunak J

Viewing 7 posts - 16 through 21 (of 21 total)

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