Home Forums SQL Server 2008 SQL Server Newbies get the last active data RE: get the last active data

  • January 25, 2018 at 7:28 am

    #1977332

    Row_number partition by name order by year and filter for that = 1 (you'll need a subquery or CTE)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass