Mastering SQL Trace Using Profiler - Microsoft SQL Server 2012 Performance Tuning - page 25

,@CustomerName
,@SalesPersonName
WHILE @@FETCH_STATUS=0
BEGIN
SELECT @OrderTotal=SUM(LineTotal) FROM [Sales].
[SalesOrderDetail]
WHERE SalesOrderID = @SalesOrderID
INSERT INTO [tempdb].[dbo].[#tbl_OrderTotals]
VALUES
(
@SalesOrderID
,@OrderDate
,@CustomerName
,@SalesPersonName
,@OrderTotal
)
FETCH NEXT FROM curSalesOrders INTO
@SalesOrderID
,@OrderDate
,@CustomerName
,@SalesPersonName
END
CLOSE curSalesOrders
DEALLOCATE curSalesOrders
SELECT * FROM [tempdb].[dbo].[#tbl_OrderTotals]
ORDER BY OrderID DESC
END
GO
--Excutes stored procedure.
EXECUTE [dbo].[usp_CalculateOrderTotals]
GO
--Drop the table if it exists
IF OBJECT_ID('[dbo].[tblSampleData]') IS NOT NULL
DROP TABLE [dbo].[tblSampleData]
GO
--Generate 5 million records and insert them into a table.
SELECT TOP 5000000 C1.*
INTO [dbo].[tblSampleData]
FROM sys.columns AS C1