Erreurs avec mon curseur

Bonjour,
J'ai une table qui contient des enregistrements que je souhaite récupérer et insérer dans une 2e table selon une colonne "Index_count" de la premiere table, quand j'exécute mon code ça me donne des erreurs sur lesquelles je seche pour le moment :

Declare @code1 varchar(10),@code2 varchar(10), @lettre2 varchar(5), @lettre3 varchar(5), @lettre4 varchar(5);
SET @code2 = NULL;
SET @lettre2 = NULL;
SET @lettre3 = NULL;
SET @lettre4 = NULL;

DECLARE curseur1 CURSOR FOR 
SELECT top 1 Code from Configuration..ngap order by 'Code';

OPEN curseur1
Fetch next from curseur1 INTO @code1;
while @@FETCH_STATUS = 0
BEGIN
if @code1<>@code2
	insert into Configuration..ngap2 values ('@code1', select top 1 Description_acte from Configuration..ngap where Code='@code1' order by 'Code',  select top 1 Lettre from Configuration..ngap where Code='@code1' order by 'Code', select top 1 Coef from Configuration..ngap where Code='@code1' order by 'Code')
if @code1=@code2
	set @lettre2 = (select lettre2 from Configuration..ngap2 where Code='@code1');
	set @lettre3 = (select lettre3 from Configuration..ngap2 where Code='@code1');
	set @lettre4 = (select lettre4 from Configuration..ngap2 where Code='@code1');
	if @lettre2 is null
		update Configuration..ngap2 set lettre2 = (select Lettre from Configuration..ngap where Code='@code1' and index_count=2)
		update Configuration..ngap2 set Coef2 = (select Coef from Configuration..ngap where Code='@code1' and index_count=2)
	if @lettre3 is null
		update Configuration..ngap2 set lettre3 = (select Lettre from Configuration..ngap where Code='@code1' and index_count=3)
		update Configuration..ngap2 set Coef3 = (select Coef from Configuration..ngap where Code='@code1' and index_count=3)
	if @lettre4 is null
		update Configuration..ngap2 set lettre4 = (select Lettre from Configuration..ngap where Code='@code1' and index_count=4)
		update Configuration..ngap2 set Coef4 = (select Coef from Configuration..ngap where Code='@code1'and index_count=4)
@code2=@code1;
FETCH NEXT FROM curseur1 into @code1;
END  
  
CLOSE curseur1;  
DEALLOCATE curseur1;  
GO

et voici les erreurs :

Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'select'.
Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'select'.
Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'select'.
Msg 102, Level 15, State 1, Line 15
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near '@code2'.