MS SQL Server - Re: counting values in a result set

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: counting values in a result set

Rory

2006-10-24, 6:37 pm

Hi Hilary,
Thanks for that, unortunately it does not work.
Regards,
--
rory

"Hilary Cotter" wrote:

> this is untested but try
>
> SELECT ahd.call_req.ref_num AS Incident, count(*)
> FROM ahd.call_req JOIN ahd.act_log
> ON ahd.act_log.call_req_id=ahd.call_req.persid
> WHERE ahd.act_log.type = 'TR'
> group by Incident
>
>
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Rory" <rory@discussions.microsoft.com> wrote in message
> news:50034587-D2A5-4CFE-A629- 09636FED3E0C@microso
ft.com...
>
>
>

Sponsored Links