I will test it as you specified and get back with you. I will also try adding the "ReturnDate is null" and the SerialNumber to the Order By.

As for the recursion:

http://msdn.microsoft.com/en-us/library/ms175972.aspx

(Notice that it does say 2012 version)