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

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

• Next in forum: Re: Group By Query Casues TimeOut Error
• Prev in forum: Query with Group By Causes TimeOut Error
• Thread view: Group By Query Casues TimeOut Error

[Reply to this message]