/*Asignar la clave del grupo a la tabla LISTAS*/
DECLARE @Clv_Grp int, @Cond varchar(30)

DECLARE CRS_ClvGrp CURSOR
	FOR SELECT Clv_cva_Grp, Bimestre+Idioma+RTRIM(Nivel)+RTRIM(Grado)+Horario As Cond
		FROM Grupos
OPEN CRS_ClvGrp

FETCH NEXT FROM CRS_ClvGrp
INTO @Clv_Grp, @Cond

WHILE @@FETCH_STATUS=0
begin
	UPDATE Listas SET Clv_cva_Grp=@Clv_Grp
	WHERE Bimestre+Idioma+RTRIM(Nivel)+RTRIM(Grado)+Horario=@Cond

	FETCH NEXT FROM CRS_ClvGrp
	INTO @Clv_Grp, @Cond
end

CLOSE CRS_ClvGrp
DEALLOCATE CRS_ClvGrp



/*Eliminart colmnas extras de LISTAS*/
ALTER Table Listas DROP Column Bimestre
ALTER Table Listas DROP Column Idioma
ALTER Table Listas DROP Column Nivel
ALTER Table Listas DROP Column Grado
ALTER Table Listas DROP Column Horario