Tablas temporas y alter table

[flaviovich]

La solucion:

Código SQL:

CREATE TABLE #TablaTemporal
(
Pais INT NULL, Nombre INT NULL
)
 
INSERT INTO #TablaTemporal ... VALORES
 
ALTER TABLE #TablaTemporal ADD [InternalID] INT IDENTITY (1,1)
ALTER TABLE #TablaTemporal ADD [RsID] INT
GO
UPDATE #TablaTemporal SET [RsID] = [InternalID]-1+(SELECT isnull(MAX (RsID)+1,1) FROM Paises)
 
ALTER TABLE #TablaTemporal DROP COLUMN [InternalID]
GO
SELECT * FROM #TablaTemporal