well let me clarify a bit here.
My hash is backwards, data file example is below.
Database has columns for Date,Login,SearchLoad,etc,
Date column is a date/time
when I read file into hash I get timevalue->columnname, I want the reverse which would be columname->timevalue.
In order to fix my data file, I want to add a label Date to the first value which is a timestamp for each record throughout the file, then I want to read the file into a hash so I can input it into the database which is currently empty and only contains the columns I want to use for the table.
The sql for the table creation is in the bottom of this comment.
05/12/2006 12:21:10 AM,Login,19.748396,SearchLoad,13.459355,SearchCoun
+05/12/2006 12:54:07 AM,Login,18.015907,SearchLoad,13.259065,SearchCou
+05/12/2006 01:21:15 AM,
/****** Object: Table [dbo].[AllResults] Script Date: 03/20/2009 1
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AllResults](
[Date] [datetime] NOT NULL,
[Login] [real] NULL,
[SearchLoad] [real] NULL,
[SearchCount] [real] NULL,
[SearchResults] [real] NULL,
[SearchSave] [real] NULL,
[SearchDelete] [real] NULL,
[SearchDetails] [real] NULL,
[ClientAdd] [real] NULL,
[CMALoad] [real] NULL,
[CMASave] [real] NULL,
[CMADelete] [real] NULL,
[ClientDelete] [real] NULL,
[Logout] [real] NULL,
[SiteCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NUL
) ON [PRIMARY]