Viewing 2 posts - 1 through 3 (of 3 total)
I've found a solution that works:
select eo.ID, eo.EventDate, gc.Grade
from #EventOccurrence eo
inner join #GradeChange gc
...
January 28, 2011 at 10:48 am
#1279832
Hi, thank you for your help!
Here's the DDL, with some changes to (hopefully) make the data more intuitive:
/* If the test table already exists, drop it */
January 28, 2011 at 7:50 am
#1279717