Home Forums SQL Server 2014 Development - SQL Server 2014 What is the best way to SELECT SUM while using PARTITION BY and WHERE and GROUP BY? RE: What is the best way to SELECT SUM while using PARTITION BY and WHERE and GROUP BY?

  • August 29, 2016 at 12:09 pm

    #1898149

    Firewolf (8/29/2016)

    ok...so those are results my code gives....well apart from "Jim"....not sure where he comes from cos he aint in your sample data :ermm:

    Yeah, let us pretend Jim doesn't exist.:-D

    so ... are you happy with the solution?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day