MAX(CreatedDate)

• rightfield

  SSCrazy

  Points: 2418

  More actions

  December 3, 2007 at 8:28 am

  #184573

  Hi experts,

  Several rows may match my WHERE clause but I only want the one with the maximum created date, MAX(CreatedDate). How would I change this;

  SELECT RememberValue

  FROM dbo.Remember

  WHERE DBName = @DBName

  AND SProcSource = @SProcSource

  AND SProcVersion = @SProcVersion

  AND RememberKey=@RememberKey

  Thank you.

• Andras Belokosztolszki

  SSC-Insane

  Points: 21971

  More actions

  December 3, 2007 at 8:31 am

  #756509

  SELECT TOP (1) RememberValue

  FROM dbo.Remember

  WHERE DBName = @DBName

  AND SProcSource = @SProcSource

  AND SProcVersion = @SProcVersion

  AND RememberKey=@RememberKey

  ORDER BY CreatedDate DESC

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• rightfield

  SSCrazy

  Points: 2418

  More actions

  December 3, 2007 at 9:30 am

  #756535

  Thank you Andras. This is perfect.

  Warm regards,

  Hope