/*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