Posted by Compliance on 08/17/06 20:18

My mistake...thanks. Now I am getting the following back, but its not
quite correct. See, unless I place the DateTime field in the GROUPBY I
get an error:

>[Error] Script lines: 1-9 --------------------------
Column 'Date/Time' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause. 
>

So when my data comes back i get the actual TimeDate and the new
Hourly, but not the summarized hourly average (AvgData) alone:

DateTime Hourly AvgData
Name
--------------------- ---------------------
------------------ ------------
7/25/2006 9:30:06 PM 7/25/2006 9:00:00 PM 82.80000 1Name
7/25/2006 9:32:03 PM 7/25/2006 9:00:00 PM 82.40000 1Name
7/25/2006 9:34:09 PM 7/25/2006 9:00:00 PM 82.09999 1TName


Thanks again.

Roy Harvey wrote:
> On Thu, 17 Aug 2006 12:02:49 -0700, you wrote:
>
> > SELECT tblRecord.HistAt
> > dateadd(hour,datediff(hour,0,HistAt),0) as Hourly,
> On Thu, 17 Aug 2006 12:02:49 -0700, "Compliance" <comcontrol@aol.com>
> wrote:
>
> > SELECT tblRecord.HistAt
> > dateadd(hour,datediff(hour,0,HistAt),0) as Hourly,
>
> There is a comma missing at the end of the first line.
>
> Roy Harvey
> Beacon Falls, CT

[Back to original message]