This is all brand new to me. Does anyone have any good resource for a complete noob to take a read of?

Thanks for the clarification!

Thanks very much, downloaded it and run it against a test database. 

One thing I am a little confused around, if you can shed any light that'd be appreciated.

Understood, and agree if I had picked up on that then I could have deduced that row_number would be insufficient for the requirement.

I guess I jumped on the data example...

I appreciate these questions every day, helps me learn new things, so I don't want to sound like a nob here, but surely the question is wrong?

'If I have this...

(Bob Brown) (2/19/2013)

The question is "does the statement will...

A true or false question, that doesn't ask one question in it, can be a little difficult to understand.

Nice.