Post reply

How to get user position in table i.e 1st 2nd, 3rd

  • June 25, 2013 at 2:38 am

    #1627023

    Hi sorry this will be the last question i ask is there a way i can extend this main query to return the number of rows,

    so at the moment is looks like this once its run

    1DA1Admin 15

    3DA7Admin 72

    4D10You2

    5D13Admin 131

    Ideally i want to extend this to be

    1DA1Admin 15 4

    3DA7Admin 72 4

    4D10You2 4

    5D13Admin 131 4

    4 being the number of rows in the cte_Select ?

  • June 25, 2013 at 2:55 am

    #1627029

    It's unclear which 5 columns you currently select in your query. You could at least mention the columnnames in your post ;-).

    Based on your quenstion I guess you can expand the list with a COUNT({column}) and a GROUP BY. But isn't that allready in the CTE with the code: "count(p.ReviewedBy) as total"? Don't you get the desired result when you select this [total] column in the outer query?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 25, 2013 at 2:58 am

    #1627030

    That correct it is already inside the cte_select statement but i need the overall count of the actually results because at the moment is does a total count for each users

    so as my previous snippet the number 4 represents the number of records in the grid.

  • June 25, 2013 at 4:04 am

    #1627042

    Can any one shed any light on this?

Viewing 4 posts - 31 through 33 (of 33 total)

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