SQL Server - Solucion de Cursores y Variable Tabla (Northwind)

--DECLARACIÓN DE VARIABLE TIPO TABLA

declare @TempTable as table

(OrderID int identity (10,5) not null, CustomerID nvarchar(5), OrderDate datetime, ShipAddress nvarchar(60), ShipCity nvarchar (15))

--INSERTAR DATOS EN LA VARIABLE TIPO TABLA

insert into @TempTable (CustomerID,OrderDate,ShipAddress,ShipCity)

select o.CustomerID,o.OrderDate,o.ShipAddress,o.ShipCity

from dbo.Orders o

where o.CustomerID = 'VICTE'

--DECLARA CURSOR

declare micursor2 cursor scroll

	for select * from @TempTable

--ABRIR CURSOR

open micursor2

--EJECUTA CURSOR

fetch next from micursor2

--cerrar cursor

close micursor2

--liberar cursor

deallocate micursor2

declare @table1 table (OrdrID int, CustomerID nchar(5), OrderDate date, ShipAddress varchar(250), ShipCity varchar(100));

--DECLARA VARIABLE NUMERO Y VARIABLES PARA TABLA

declare @Numero int=10,

		@CustomerID nchar(5),

		@OrderDate date,

		@ShipAddress nvarchar(60),

		@ShipCity nvarchar(15)

--DECLARA CURSOR

declare ordenes cursor

	for select o.CustomerID,o.OrderDate,o.ShipAddress,o.ShipCity

		from dbo.Orders o

		where o.CustomerID='VICTE'

--ABRIR CURSOR

open ordenes

--EJECUTAR CURSOR

fetch next from ordenes into @CustomerID,@OrderDate,@ShipAddress,@ShipCity

while (@@FETCH_STATUS=0)

	begin

		insert into @table1 select @Numero,@CustomerID,@OrderDate,@ShipAddress,@ShipCity

		set @Numero = @Numero + 5

		fetch next from ordenes into @CustomerID,@OrderDate,@ShipAddress,@ShipCity

	end

--CIERRA CURSOR

close Ordenes

--LIBERA MEMORIA

deallocate Ordenes

--SELECT PARA VARIABLE TABLA

select * from @table1