如何避免在Sybase（T-SQL）中使用游标？

Imagine the scene, you're updating some legacy Sybase code and come across a cursor. The stored procedure builds up a result set in a #temporary table which is all ready to be returned except that one of columns isn't terribly human readable, it's an alphanumeric code.Imagine the scene, you're updating some legacy