What's going on - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

What's going on

Author

Topic

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2001-07-06 : 10:48:05

When i run this query
SELECT A.NDC, A.TRADENAME, AGPIF.CLASS AS Generic
FROM A LEFT JOIN AFPIF ON A.NDC = AFPIF.NDC LEFT JOIN AGPIF ON AFPIF.GENERIC = AGPIF.GENERIC
I get this error

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

But When i use the same query as derived table i don't get error

SELECT NDC,Tradename,Generic from
(Select A.NDC, A.TRADENAME, AGPIF.CLASS AS Generic
FROM A
LEFT JOIN AFPIF
ON A.NDC = AFPIF.NDC
LEFT JOIN AGPIF
ON AFPIF.GENERIC = AGPIF.GENERIC)a
Where TRADENAME Like 'pi'+'%'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources