is this a typo in the question?.

I think to get this answer the declartion of the identity should by (-1,-1)

If you insist on using a cursor.

You should check the @@getstatus after the fetch next or, before the fetch next, initialze your variable on NUll and after the...