Search results for query: *

  • Users: andyj
  • Order by date
  1. andyj

    Top Sales Help Required

    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
  2. andyj

    Top Sales Help Required

    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...
  3. andyj

    Top Sales Help Required

    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...
  4. andyj

    Top Sales Help Required

    That SQL is WAY beyond me! but it works! I have a real good chance of getting this app up and running now. THANKS! Andy
  5. andyj

    Top Sales Help Required

    :D I have both! Planning on SQL 2000 though. Yes TransactionID would be the single PK. Thanks Andy
  6. andyj

    Top Sales Help Required

    I'm using SQL Server 2000 or 2005...
  7. andyj

    Top Sales Help Required

    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...
  8. andyj

    Top Sales Help Required

    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...
  9. andyj

    Repeater for XML data in Windows Forms

    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...
Back
Top