"john smith" <dwinre2000@yahoo.com> wrote in message
news:bkdndo$5nn0$1@news3.infoave.net...
> I am trying to get a query to work using grouping by days
>
> SELECT CAST(datepart(dd,date_created) AS int) AS DOW, SUM(prod_unique) as
> unique_count, COUNT(prod_id) as total_hits,
> (COUNT(prod_id) - SUM(prod_unique)) AS total_returns
> FROM crm_ecom_tracker
> WHERE datepart(yyyy,date_created) = @spYear AND datepart(m,date_created) =
> @spMonth AND org_id = @spOrg_id and prod_id = @spProd_id
> GROUP BY CAST(datepart(dd,date_created) AS int)
> ORDER BY CAST(datepart(dd,date_created) AS int) DESC
>
>
> RETURN @@ROWCOUNT
>
> The problem is when i try to add generic fields i get the field is invalid
> because it is not an aggregate function. Since it is a tracking query the
> results need to be grouped by the day of the week.
>
> Thanks for any help,
> Donnie
>
>

"john smith" <dwinre2000@yahoo.com> wrote in message
news:bkdndo$5nn0$1@news3.infoave.net...
> I am trying to get a query to work using grouping by days
>
> SELECT CAST(datepart(dd,date_created) AS int) AS DOW, SUM(prod_unique) as
> unique_count, COUNT(prod_id) as total_hits,
> (COUNT(prod_id) - SUM(prod_unique)) AS total_returns
> FROM crm_ecom_tracker
> WHERE datepart(yyyy,date_created) = @spYear AND datepart(m,date_created) =
> @spMonth AND org_id = @spOrg_id and prod_id = @spProd_id
> GROUP BY CAST(datepart(dd,date_created) AS int)
> ORDER BY CAST(datepart(dd,date_created) AS int) DESC
>
>
> RETURN @@ROWCOUNT
>
> The problem is when i try to add generic fields i get the field is invalid
> because it is not an aggregate function. Since it is a tracking query the
> results need to be grouped by the day of the week.
>
> Thanks for any help,
> Donnie
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23kwBu0lfDHA.1888@TK2MSFTNGP12.phx.gbl...
> I seem to be missing the part where your adding fields, can you be more
> specific. What exactly is the error? By the way there is no need to cast
> the Datepart as an integer since it is an integer.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "john smith" <dwinre2000@yahoo.com> wrote in message
> news:bkdndo$5nn0$1@news3.infoave.net...
> > I am trying to get a query to work using grouping by days
> >
> > SELECT CAST(datepart(dd,date_created) AS int) AS DOW, SUM(prod_unique)
as
> > unique_count, COUNT(prod_id) as total_hits,
> > (COUNT(prod_id) - SUM(prod_unique)) AS total_returns
> > FROM crm_ecom_tracker
> > WHERE datepart(yyyy,date_created) = @spYear AND datepart(m,date_created)
=
> > @spMonth AND org_id = @spOrg_id and prod_id = @spProd_id
> > GROUP BY CAST(datepart(dd,date_created) AS int)
> > ORDER BY CAST(datepart(dd,date_created) AS int) DESC
> >
> >
> > RETURN @@ROWCOUNT
> >
> > The problem is when i try to add generic fields i get the field is
invalid
> > because it is not an aggregate function. Since it is a tracking query
the
> > results need to be grouped by the day of the week.
> >
> > Thanks for any help,
> > Donnie
> >
> >
>
>

"john smith" <dwinre2000@yahoo.com> wrote in message
news:bkfmhd$6vlb$1@news3.infoave.net...
> Like if I added ...
>
> date_created,ip_address,browser
>
> ... to the query. I can't use any non aggregate returns
>
> error ...
> "dbo.table.column_name" is invalid in the select list because it is not
> contained in either an aggregate function or group by clause.
>
> Thanks,
> Donnie
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23kwBu0lfDHA.1888@TK2MSFTNGP12.phx.gbl...
> > I seem to be missing the part where your adding fields, can you be more
> > specific. What exactly is the error? By the way there is no need to
cast
> > the Datepart as an integer since it is an integer.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "john smith" <dwinre2000@yahoo.com> wrote in message
> > news:bkdndo$5nn0$1@news3.infoave.net...
> > > I am trying to get a query to work using grouping by days
> > >
> > > SELECT CAST(datepart(dd,date_created) AS int) AS DOW, SUM(prod_unique)
> as
> > > unique_count, COUNT(prod_id) as total_hits,
> > > (COUNT(prod_id) - SUM(prod_unique)) AS total_returns
> > > FROM crm_ecom_tracker
> > > WHERE datepart(yyyy,date_created) = @spYear AND
datepart(m,date_created)
> =
> > > @spMonth AND org_id = @spOrg_id and prod_id = @spProd_id
> > > GROUP BY CAST(datepart(dd,date_created) AS int)
> > > ORDER BY CAST(datepart(dd,date_created) AS int) DESC
> > >
> > >
> > > RETURN @@ROWCOUNT
> > >
> > > The problem is when i try to add generic fields i get the field is
> invalid
> > > because it is not an aggregate function. Since it is a tracking query
> the
> > > results need to be grouped by the day of the week.
> > >
> > > Thanks for any help,
> > > Donnie
> > >
> > >
> >
> >
>
>