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.
Any assistance is appreciated (using sqlServer2000).
Thank you.