[TCP/IP Sockets]ConnectionCheckForData (CheckforData())

MS SQL 2000.
When I attempt a SELECT I get the following:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionChe
ckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
The offending SELECT
select a.account
from table1 a
where a.doc = '123456A'
and (select count(1)
from table1 b
where a.account = b.account
and a.doc = b.doc
and a.oseq = b.oseq
and a.party = b.party) > 1
If I do the SELECT with out the sub select it works fine. Suggestions?Hi Scott
Having DDL and sample data with the expected results from that data would be
nice. See http://www.aspfaq.com/etiquette.asp?id=5006
"Scott Sheen" wrote:

> MS SQL 2000.
> When I attempt a SELECT I get the following:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionC
heckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
>
> The offending SELECT
> select a.account
> from table1 a
> where a.doc = '123456A'
> and (select count(1)
> from table1 b
> where a.account = b.account
> and a.doc = b.doc
> and a.oseq = b.oseq
> and a.party = b.party) > 1
If this worked it wouldreturn multiple rows of the same account number

>
How about :
SELECT a.account
FROM table1 a
JOIN table1 b ON a.account = b.account
and a.doc = b.doc
and a.oseq = b.oseq
and a.party = b.party
WHERE a.doc = '123456A'
GROUP BY a.account
HAVING COUNT(*) > 1

> If I do the SELECT with out the sub select it works fine. Suggestions?
>
John|||Reworking the statement worked around the issue.
examnotes <jbellnewsposts@.hotmail.com> wrote:
>Hi Scott
>Having DDL and sample data with the expected results from that data would b
e
>nice. See http://www.aspfaq.com/etiquette.asp?id=5006
>"Scott Sheen" wrote:
>
>If this worked it wouldreturn multiple rows of the same account number
>
>How about :
>SELECT a.account
>FROM table1 a
>JOIN table1 b ON a.account = b.account
> and a.doc = b.doc
> and a.oseq = b.oseq
> and a.party = b.party
>WHERE a.doc = '123456A'
>GROUP BY a.account
>HAVING COUNT(*) > 1
>
>John|||Hi Scott
"Scott Sheen" wrote:

> Reworking the statement worked around the issue.
>
Was this the statement I posted or something different? How many I/O is it
doing?
John