Home Forums SQL Server 2008 T-SQL (SS2K8) Selecting the Row with the MAX(DateStarted) RE: Selecting the Row with the MAX(DateStarted)

  • October 16, 2013 at 11:10 pm

    #1659118

    dwain.c (10/16/2013)

    As long as you don't have any duplicates in the MAX date:

    SELECT * FROM #AllData WHERE CONVERT(VARCHAR(20),DateStarted) + CONVERT(VARCHAR(30), ProductID) IN(

    SELECT CONVERT(VARCHAR(20),max(DateStarted))+ CONVERT(VARCHAR(30), ProductID) FROM #AllData

    group BY ProductID)