set nocount on
 declare @POSITION_name varchar(100), @sql_id varchar(5) , @n int

 declare cur cursor for
   select POSNAME from [recruit].RCT_POSITION
 open cur
  fetch next from cur into @POSITION_name
  
 while @@fetch_status=0
 begin
  print @position_name
  insert into [recruit].mst_position (position_name) values(@POSITION_name)

  fetch next from cur into @POSITION_name

   end
  close cur
 deallocate cur /* คืนทรัพยากร*/

 set nocount off