Listing A


IF OBJECT_ID('SalesHistoryArchive')>0     
DROP TABLE [SalesHistoryArchive];
GO
CREATE TABLE [dbo].[SalesHistoryArchive] 
(           
       [SaleID] [int] IDENTITY(1,1),           
       [Product] [varchar](10) NULL,                 
       [SaleDate] [datetime] NULL,                 
       [SalePrice] [money] NULL
)ON [ps_Product_Scheme](Product) 
GO 

DECLARE @i SMALLINT
SET @i = 1
WHILE (@i <=10000)
BEGIN                       
    INSERT INTO SalesHistoryArchive(Product, SaleDate, SalePrice)                       
    VALUES('Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57))     
    INSERT INTO SalesHistoryArchive(Product, SaleDate, SalePrice)           
    VALUES('BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13))                 
    INSERT INTO SalesHistoryArchive(Product, SaleDate, SalePrice)               
    VALUES('PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29))                        
    SET @i = @i + 1
END