Thanks that is working... for some reason when I wrote the statement, it did not like the precision part of decimil.

Thank you for your response... I am not sure how this would work, as it will just return the last date in the given month, not the date that contained...

Opening this up to the forurm... I need insert the following query as a column:

Select Class, vDate 'Date of Peak', Volume

FROM #tblTemp

Where Volume in (Select Max(Volume) From...

Sleep does a wonder...  one question/comment.   I need to intergate the date of where the Max(Volume) occured.  The stand-alone query that works right now is:

Select Class, vDate, Volume FROM #tblTemp...

Are you using a insert trigger to split it?

Tim,

I ran your code in QA this morning.  What I would like the output to accomplish is at this point is 24 rows with the total volume listed by hour...

Thank you Tim for the code... I will try it out this afternoon, and get back with you.  Once again, I appreciate all your help and understanding of this issue.

Thanks for your reply... to answer your question:

 [StartDate] [datetime] NOT NULL ,

 [StartTime] [datetime] NOT NULL ,

 [EndDate] [datetime] NULL ,

 [EndTime] [datetime] NULL ,

 [Operator] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Volume] [int] NULL...

The Stored Procedure is used to format the data from multiple tables based upon the search criteria (hence not using a view) and produce meaningful data that will need to...

Peter,

Serigy,

Unfortunately, I only have read rights to this server and I did not see the reason to have a table create when there will only be the three values V1,...

May of jump the gun a little bit... the subquery usually took 1min 10sec to run... I added the outside select statement and the group by statements and finally killed...

Ahhh...  I forgot to name the derived table (DT)

Thanks...

Thank you for the quick response... I tried that and in my WHERE clause I am using an IN statement which uses ('V1',V2','V3') etc...  and SQL doesn't like the double...