SQL Server: Procedimiento Almacenado con Tabla temporal

[jaielsaun]

Código:

DECLARE @Id AS varchar(8)
DECLARE @Codigo AS int
DECLARE @NuevoId AS varchar(8)


SELECT TOP 1 @Id = IdCodigo FROM #Empleados WHERE left(IdCodigo, 4) = '0310' order by IdCodigo DESC

SET @Codigo = CAST(substring(@Id, 5, 4) AS int) + 1

SET @NuevoId = '0310' +  RIGHT('0000' + CAST(@Codigo AS varchar(4)),4)

INSERT INTO #Empleados (Id, Nombre, Dir) VALUES (@NuevoId,'Juan','Dire')