Need help

• gentilep

  SSC Journeyman

  Points: 82

  More actions

  June 19, 2012 at 2:17 pm

  #260182

  I have a table that has product receiving in it, I need to retrieve the max receipt date for an item and the user who received it - how can I do this in sql??

  Pete Gentile

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 19, 2012 at 2:23 pm

  #1503096

  Well, with no details from which to work, here is a shot in the dark.

  WITH basedata AS (

  SELECT

  ROW_NUMBER() OVER (PARTITION BY ProductID ORDER BY ReceiptDate DESC) AS rn,

  ProductID,

  ReceiptDate,

  UserName

  FROM

  dbo.ProductTable -- Or what ever it is called

  )

  SELECT

  ProductID,

  ReceiptDate,

  UserName

  FROM

  basedata

  WHERE

  rn = 1;