asked
tsql group by join
Have 2 tables TableA StudentID MeetingID TeacherID Date 001 1002581 1056 10-12-2012 001 1006789 1056 10-13-2012 001 1006754 1058 10-13-1012 Have one more table B StudentID MeetingID TeacherID Date Value 001 1002581 1056 10-12-201 15 001 1002856 1056 10-20-2012 21 The conditions are max(date) of a particular student teacher meeting from table A matches the max(date) of the same student teacher meeting in table B with the value. I would like to see the resultset as something like StudentID MeetingID TeacherID Date Value 001 1006789 1056 10-20-2012 21 How can i achieve the above resultset
It sounds a lot like the versioned data I've worked with before. [I wrote up an article][1] using various methods to retrieve the data. Check this out. I'm sure one of them will meet the requirements you're looking for. [1]:
http://www.simple-talk.com/sql/database-administration/sql-strategies-for-versioned-data/
10 People are following this question.
