用啥方法能替代存储过程中的游标

其实就是遍历以下这些数据了,
asxcode FirstName       Surname         position
--------------------------------------------------------
AAA Graham         Riley         Chairman
AAA Mark         Foley         CEO/MD
AAA Joshua         Pitt         Director (other)
AAA Peter         Ruttledge Company Secretary
AAA Stanley         MacDonald Director (other)
AAA Peter         Bilbe         Director (other)
AAA Michael         Walsh         Director (other)
AAA Arun         Jagatramka Director (other)
AAA Garry         Strong         Director (other)
AAA Philip         Galloway Director (other)
AAA Constantino Markopoulos Director (other)
AAA Glenn         Ferguson Director (other)
AAB Ann         Hadden         Company Secretary
AAB Michael         Devlin         Chairman
AAB Deon         Joubert         CEO/MD
AAB Jonathan Eriksen         Director (other)
AAC D         Connolly Executive/Management
AAC M         Tighe         Executive/Management
AAC G         Wagstaff Executive/Management
AAC P         Marwedel Executive/Management
AAC Charles         Bright         Director (other)
AAC Timothy (Tim) Fischer         Director (other)
AAC Nicholas Burton Taylor Chairman
...........................................
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
然后把同样的代码整理到表CurrentDirectorsComb中一行数据；
asxcode  CEO                            Chairman                      CompSec
----------------------------------------------------------------------------------
AAA Mark Foley                 Graham Riley              Peter Ruttledge
AAB Deon Joubert                 Michael Devlin              Ann Hadden
AAC                         Nicholas Burton Taylor      Bruce Bennet
AAD Jochen Dobel, R Capdevila David Baffsky              J Nugawela
AAE Peter Anderton                 Peter Anderton              Bruce Arnold, Roberto Pedulla
AAF                                              Malcolm Smartt, David McArthur
AAG Paul Benson                 Peter Cook              Andrew Chapman
AAG1 J Griffith                 Alan Newman              R Harbison
AAH John Chiplin                 Robin Beaumont              Niall Henderson