Post reply

Getting the LATEST DATE in the table

  • March 5, 2007 at 2:16 pm

    #172292

    How to modify the below procedure in order to get the latest date ( the biggest value ) in the column “Deadline”, type smalldatetime, ( example: 24/02/2007 00:00:00 ) for a given customer “UserName” ?

     

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    CREATE PROCEDURE GetLatestDate

    (@UserName VARCHAR(50)

    AS

    SELECT Deadline

    FROM CustomerItems

    WHERE UserName = @UserName

  • March 5, 2007 at 2:38 pm

    #693215

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    CREATE PROCEDURE GetLatestDate

    (@UserName VARCHAR(50)

    AS

    SELECT Max(Deadline)

    FROM CustomerItems

    WHERE UserName = @UserName

    And then again, I might be wrong ...
    David Webb

  • March 5, 2007 at 5:25 pm

    #693231

    Thank you, David.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply