467,911 Members | 1,404 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,911 developers. It's quick & easy.

Query with Group By Causes TimeOut Error

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

Oct 22 '06 #1
  • viewed: 1347
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dunc | last post: by
6 posts views Thread by Martin Eyles | last post: by
4 posts views Thread by mikado | last post: by
reply views Thread by laurenquantrell | last post: by
5 posts views Thread by Chris Kennedy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.