chrismat (9/11/2012)
Kingston Dhasian (9/11/2012)
What are the expected results based on your data?If you copy/paste my post into SSMS and run it, the last active result set contains some question marks. My expected results are the question marks need to be incrementing numbers; the number is based on MAX(Sibling)+1 for the group Sponsor=4; in this example they would start at 3, but in general it could start at any number depending on what the max(sibling) returned for a given group.
The question is, based on the sample data, what should the expected output look like. This means we would like you to play the computer and manually generate the result set you are expecting the code to actually generate.