set rowcount @begin

SELECT ProductId, ProductName, QuantityPerUnit,	
	UnitPrice, UnitsInStock INTO #tmp1 FROM products

set rowcount @view

SELECT * INTO #tmp2 FROM #tmp1 ORDER BY ProductId DESC
SELECT * FROM #tmp2 ORDER BY ProductId