Perfect!
Thanks cjard! sorry for the late reply I have been away.
Have just tried this out and read through it a few times, not only does it work but with your explanations I'm starting to understand it :-)
Andy
I've tried it, but getting nowhere.
SELECT BowlerId,
sum(best) AS best,
sum(secondbest) AS secondbest,
sum(thirdbest) AS thirdbest, sum(best + secondbest + thirdbest) AS total
FROM
(
SELECT...
OK, its going really well but there is something else that has me stumped :confused:
Where would I put the INNER JOIN statement to pull in the name from the "salespeople" table ?
I've tried a few places, but I'm getting myself in a muddle with where to put it and where to use table...
Thanks aBsOlUt
That's looking pretty good, but that gives me the results in the datagridview with each transaction in a row. I need to group those transactions so that the look like below
EmployeeId - TopSale1 - TopSale2 - TopSale3 - Top3SalesTot
rather than
EmployeeId - Amount...
Hi all,
I'm looking for some help with something I've got myself a bit lost on :confused:
I need to create a ranking list of salespeople, BUT only their "TOP" 3 sales count... I then need to display this on a winforms app (for a scoreboard) and be able to print out the result.
There will...
Greetings all, my first post :D
I want to pull in some XML data into a windows forms project and have it displayed in the same way as I have seen so many time on asp pages using a repeater object.
Can anyone give me some ideas about how to do this in winforms or a pointer to a winforms tool...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.