Re: SQL query

From: Henry (nospam_at_thanks.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 22:05:06 +0100

> Since you can't use the alias in the group by, you'll have to use the
> expression instead:
>
> SELECT digits,
> DATEPART (hh, DATECALLINITIATED) as calltime,
> COUNT(*) as Kald
> FROM [38335.TXT]
> GROUP BY digits,
> DATEPART (hh, DATECALLINITIATED)
>
>
> >PS. sorry if this is the wrong group, I just couldn't find a more
suitable
> >froup.
>
> This group is fine, but the best group for questions about queries in MSDE
> and other SQL Server editions is microsoft.public.sqlserver.programming.
>
> Best, Hugo

Thanks Hugo, that was a great explaination.

I'll ask my query questions in programming.

regards
Henry

Relevant Pages

  • Re: Splitting double into integers
    ... zeros. ... You want to know the number of digits in the fractional ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Separating Numbers
    ... > want to divide them into parts of 4 digits in each parts. ... >> Regards, ... >> Peo Sjoblom ... >>> Himu. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting and sorting US dates into European format?
    ... Best regards, ... >> use double digits, but most do not. ... >>> the Swedish version looks like ... >>> Peo Sjoblom ...
    (microsoft.public.excel)
  • RE: Trying to Change Axes
    ... > If you want to stick to 2 significant digits after the decimal, ... >>> REgards, ... >>> B. R. Ramachandran ...
    (microsoft.public.excel.charting)
  • Re: Telephoning A Russian Village
    ... It is mandatory ... > You can try Moscow operator or ask your Moscow friends to make it. ... >> is six, rather than 7 digits. ... >> regards, ...
    (soc.culture.russian)