thanks,

I made the amendments, in the code you provided you had <= 4 which again returned more then the desired results

so i done this

;with cte_select as

(select

ROW_NUMBER() over (order by count(p.ReviewedBy)...

I ok i understand,

But doing that will return the first top 4 agents,

I still need to have

My position

person above me

person below me

+ the top performer

?

hi thanks,

This is the snippet, i think i may have the replaced something incorrectly as now it returns 10 rows.....

;with cte_select as

(select

ROW_NUMBER() over (order by count(p.ReviewedBy) desc) as rownr

,...

Sorry to be a pain, can you tell me how i can return the top performer as well as the additional three rows?

Correct, i changed firstname to shortabbr seems to be working 🙂

I cant thank you all enough for helping me on this.

Really was rattling my brain.

Many thanks!

HanShi (6/20/2013)

---

This is the code if you want only the row for...

Hi Thanks for the snippet,

That returns all individuals + the amount they have checked,

Im going to be passing in the shortabbr from the front end which will then call...

i tried creating this on SQLFiddle but again this didnt work for some reason,

its a cut down version of the prospectlead table and this table has loads of columns

CREATE...

GilaMonster (6/20/2013)

---

Ok, so the 1st user is the one who has the most rows with their name in the ReviewedBy, the 2nd user is the one with the second most...

The count is by the Column ReviewedBy which stores the users shortabbr vachar(3) (So i count how many records the users has done by that column by passing in the...

Hi GilaMontser,

The position would be created depending on how many records the user has checked(ReviewedBy in prospectLead), there is a total of 15 users that check the data on a...

Thanks for the snippet, and additional information.

Hi,

Im still confused on why negative numbers are used because from my eyes when u look at

WHEN Ordertype = 3 THEN -2

WHEN Ordertype = 1 THEN -1

if its 3 -2...

Would you please be able to explain to me what these two lines do

WHEN Ordertype = 3 THEN -2

WHEN Ordertype = 1 THEN -1

Because to me when its 3 that...

simple as that!!

Thanks so much!!!