Nested cursors, multiple result sets
select obj.PK_ObjectID, obj.name, obs.timestamp, obs.note -- etc
from   Objects as obj
join   Pts     as obs
on     obj.PK_ObjectID = FK_ObservationID
order by obj.PK_ObjectID, obs.FK_ObservationID


You're googling the wrong places, if I may say so.  You yourself say you're new to SQL, and yet you've figured out how to implement a cursor instead of writing an elementary JOIN.  You wrote 33 lines where 5 will do, and ensured your query will run 1% as fast as it normally would.  

I hearby award you one gold star for asking!  Now get cracking with a good SQL book such as An Introduction to Database Systems (8th Edition), 2003, C.J. Date.