Hello, I have a table called Surveys:
There many be many rows per surveyId.
I will pass in two parameters: @SurveyIdThisYear and @SurveyIdLastYear.
Status can be a, b or c.
My statement needs to return all rows where status went from
from b to c
form a to b
How can I accomplish this???