Home Forums SQL Server 2008 T-SQL (SS2K8) Need to find out the latest STATUS of each Consumers on a given date from their Activities RE: Need to find out the latest STATUS of each Consumers on a given date from their Activities

  • March 8, 2013 at 1:37 pm

    #1595119

    @SQL_FS...... You got it right. Thanks for catching my mistake. Yes, for 101 the LatestStatus should be INACTIVE on April04,2012,

    @sean......thanks for your query. Your query can give me the LatestStatus. Sorry, if I confused you from my example as I pointed out by "SQL_FS". I want to know the LatestStatus for a member on a given date and I want to a parameter in this date so that the user can select any date and not just the latest date.

    Let me know if I need to clarify further.

    Thanks.