USE [test]

GO

/****** Object: Table [dbo].[d0003] Script Date: 19/12/2012 10:36:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[d0003](

[Date&TimeOfReading] [varchar](max) NULL,

[MPAN] [varchar](max) NULL,

[P1] [varchar](max) NULL,

[P2] [varchar](max) NULL,

[P3] [varchar](max) NULL,

[P4] [varchar](max) NULL,

[P5] [varchar](max) NULL,

[P6] [varchar](max) NULL,

[P7] [varchar](max) NULL,

[P8] [varchar](max) NULL,

[P9] [varchar](max) NULL,

[P10] [varchar](max) NULL,

[P11] [varchar](max) NULL,

[P12] [varchar](max) NULL,

[P13] [varchar](max) NULL,

[P14] [varchar](max) NULL,

[P15] [varchar](max) NULL,

[P16] [varchar](max) NULL,

[P17] [varchar](max) NULL,

[P18] [varchar](max) NULL,

[P19] [varchar](max) NULL,

[P20] [varchar](max) NULL,

[P21] [varchar](max) NULL,

[P22] [varchar](max) NULL,

[P23] [varchar](max) NULL,

[P24] [varchar](max) NULL,

[P25] [varchar](max) NULL,

[P26] [varchar](max) NULL,

[P27] [varchar](max) NULL,

[P28] [varchar](max) NULL,

[P29] [varchar](max) NULL,

[P30] [varchar](max) NULL,

[P31] [varchar](max) NULL,

[P32] [varchar](max) NULL,

[P33] [varchar](max) NULL,

[P34] [varchar](max) NULL,

[P35] [varchar](max) NULL,

[P36] [varchar](max) NULL,

[P37] [varchar](max) NULL,

[P38] [varchar](max) NULL,

[P39] [varchar](max) NULL,

[P40] [varchar](max) NULL,

[P41] [varchar](max) NULL,

[P42] [varchar](max) NULL,

[P43] [varchar](max) NULL,

[P44] [varchar](max) NULL,

[P45] [varchar](max) NULL,

[P46] [varchar](max) NULL,

[P47] [varchar](max) NULL,

[P48] [varchar](max) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

Sorry, it's actually called Date&TimeOfReading