Comment by fsuts

As said above, SQL is a set based language and one shouldn’t write a cursor to deal with individual rows unless no other way.

And if writing a server side cursor, probably better to write a stored procedure /function and put the cursor and its logic in it, and then call that rather than handle in application