I have a table called surveys with

[andremc]

I have a table called surveys with columns (store_id, survey_date) Store_id is an int, survey_date is a datetime. They query I need to write needs 2 greatest survey dates for each store in one bitlist.

Any assistance is appreciated (using sqlServer2000).
Thank you.

 

[JamesLean]

Try this:

SELECT store_id, survey_date
FROM surveys s
WHERE survey_date IN (
  SELECT TOP 2 survey_date
  FROM surveys
  WHERE store_id = s.store_id
  ORDER BY survey_date DESC
)
ORDER BY store_id, survey_date

--James

 

[andremc]

JamesLean,
Thank you!! Works like a charm.