Posted by laurenquantrell on 10/22/06 16:24

Apologies for the multiple posts in this group. My connection kept
getting dropped and I didn't know the post had succeeded. lq

On Oct 22, 12:21 pm, "laurenquantrell" <laurenquantr...@hotmail.com>
wrote:
> I have a table with 6 million rows.
> I'm trying to perform a group by query that incudes a row count of the
> PK column:
>
> SELECT COUNT(DataID) AS Cnt, Column1Name
> FROM dbo.TableName
> WHERE (Column2Name = N'p')
> GROUP BY Column1Name
>
> I have the query timeout set to 0 in Enterprise Manger. However, if I
> run this query, either in Enterprise Manager or in Query Analyzer, I
> get the following error message:
>
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> A little baffled as to why and how to run this query.
>
> Any help is appreciated.
> lq

[Back to original message]