CREATE TABLE [dbo].[LocalNASDAQ] ( [Date] [datetime] NULL , [Symbol] [char] (5) NULL , [Close] [char] (10) NULL , [Volume] [char] (10) NULL ) ON [PRIMARY] GO BEGIN INSERT INTO [dbo].[LocalNASDAQ] VALUES ( '05/31/01', 'MSFT', '69.18', '35340000' ) INSERT INTO [dbo].[LocalNASDAQ] VALUES ( '05/31/01', 'INTL', '12.51', '69700000' ) INSERT INTO [dbo].[LocalNASDAQ] VALUES ( '05/31/01', 'CSCO', '19.26', '57090000' ) END