>How do I look at the cursor before runtime?

I suggest you work out the SELECT statement in the command window instead of having to compile and run to debug it.

Next, I suggest you start with just part of what you need to do, and build it up.