My sincere thanks to each one of you who helped me here and gave their suggestions. It helped me a lot to figure out the best practice to use...

I am bit confused, sorry about that. If i use the above code will that create a table Primary and insert the data? I dont want to create any table...

Luis, Thank you for the code and the suggestion. Really Appreciate it. We need to show hours in the secondary table as in the front end GUI we got to...

Thank you Tom. Appreciate it.

Hanshi, I am sorry for not being clear. I have a SQL table called Primary that gets the data from a csv file. This primary table has following columns (DealNumber,StartDate,Enddate,MW,Price)....

I created two tables as you mentioned above Billingday & BillingHour. Also inserted records for both the table.

Could you help me with a sample SQL query to display...

Here is the code:

USE [METERS]

GO

/****** Object: Table [dbo].[IntegratedHour_MV90] Script Date: 12/1/2014 11:00:11 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntegratedHour_MV90](

[IntegratedHourId] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[CustomerName] [nvarchar](50)...

Here the code:

USE [METERS]

GO

/****** Object: Table [dbo].[IntegratedHour_MV90] Script Date: 12/1/2014 11:00:11 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntegratedHour_MV90](

[IntegratedHourId] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[CustomerName] [nvarchar](50) NOT...

Jeff,

Could you show me some sample sql statement to create like you mentioned above.

The table structure which I gave stores the meter data for each customers on an hourly basis...

Sean,

I am sorry,i get .cvs file from the client on monthly basis and i manipulate that in excel and give them the report. Sorry again.

Hi,

Thank you very much for the your response.

The above table structure is where we store the hourly data for all the units. We dont have any other table or...

Hi Luis,

I read your post and tried that for testing. I being a developer it didnt allow me to do insert bulk load because of the rights issue. Thats why...

Thank you Jeff, Could you or anyone give me a sample code to test it out.

Jim,

Thanks for your response.

I just got an update here, the client will be sending us the source (csv) file with the date and time together. so, that will...

Steve,

I'm on the client pc (local) working in .net platform and this application was developed 5 years ago and it doesnt gave me an error in the past. The Production...