Viewing 15 posts - 31 through 45 (of 102 total)
I can upload anything to the internet within working hours im afraid really strict rules here 🙁
July 21, 2014 at 9:25 pm
Please excuse this, I managed to get it resolved by making the ItemId the PK with Identity Increment.
May 31, 2014 at 4:37 am
that's correct I used the management studio to create the table, I pressed f4 but I'm unsure what I'm looking for?
May 18, 2014 at 4:12 am
OK so it turns I'm out I'm and idiot, I had an ID (Identity column) which I can reference, now sure why he was using Row_Number but any how got...
March 17, 2014 at 1:12 pm
I see, well I did come across an interesting post regarding the mappings which is here[/url] he's explaining the exact problem I'm having + he gave a solution, now I...
March 12, 2014 at 3:19 pm
Luis Cazares (8/6/2013)
I see letter k in both rows.Kipling Road
Alexandra Park
I actually feel like an idiot! this just goes to shows I was completely shattered last night.
I'm sorry for my...
August 7, 2013 at 12:16 am
Can any one shed any light on this?
June 25, 2013 at 4:04 am
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...
June 25, 2013 at 2:58 am
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...
June 25, 2013 at 2:38 am
In the main select is returns every single user i have in the DB even though i have specified what users i want i.e
Reponsibility, Department and location as soon as...
June 24, 2013 at 6:37 am
OK i spoke to soon,
Iv just run the snippet which returned this
1DA1Admin 15
250D11Admin 110
251D12You0
252D13Admin 130
first column being the position?
it should say
1DA1Admin 15
11D11Admin 110
12D12You0
13D13Admin 130
June 24, 2013 at 3:21 am
Its working i ammended the second select statement
select *
from cte_select
WHERE (CurrentPosition >= (SELECT CurrentPosition - 1 -- Get the agent before @ShortAbbr passed in
from cte_select join UserAccount u on cte_select.shortabbr...
June 24, 2013 at 3:16 am
Hi thanks for the infomation seems to be working correctly when i choose admin.1 being the top performer
but as soon as i choose the last admin user for example d13...
June 24, 2013 at 3:07 am
Hi Sorry to bring this post back to life, but is there a way i can also return the users that have a count of 0?
As this query requires the...
June 24, 2013 at 2:23 am
Viewing 15 posts - 31 through 45 (of 102 total)