471,088 Members | 1,284 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,088 software developers and data experts.

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.

Oct 22 '06 #1
0 1422

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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.