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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-18 : 10:47:51
|
| Virginia Andersen writes "I have Corelated Sub Query as Follows:SELECT P.GAID AS GAID ,P.PolicyNum AS GA_Policy_Code,Year(RD.TransactionDate) AS Period_Year,Month(RD.TransactionDate) AS Period_Month,ISNULL((SELECT SUM(Revenue) FROM RevenueDetail WHERE MONTH(DATEADD(MONTH,1,TransactionDate)) = Month(RD.TransactionDate) AND Year(TransactionDate) = Year(RD.TransactionDate) AND PolicyID = P.PolicyID), 0) AS Prev_Revenue_RecognizedFROM Policy AS P LEFT JOIN RevenueDetail AS RD ON P.PolicyID = RD.PolicyIDGROUP BY P.GAID, P.PolicyNum, P.PolicyID, Year(RD.TransactionDate), Month(RD.TransactionDate)ORDER BY P.GAID, P.PolicyNum, P.PolicyID, Year(RD.TransactionDate), Month(RD.TransactionDate)________________________I get the folowing error msg. Sometimes it includes :"Changing Language to English"___________________[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (NLReadFile()).[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.Connection Broken_______________________The error is inconsistent. Sometimes the query runs, sometimes not. The connection is fine, simple queries still run. At one point I thought I had it linked to the data, but that proved wrong. Any idea of what could be wrong with this query??" |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-18 : 14:14:29
|
| I don't see any problem with the query. I would probably suspect that you have more of a problem using named pipes rather than tcp/ip as your message is related to a communication failrue. try changing your client network utility settings to use TCP/IP over namedpipes. JamesH. |
 |
|
|
|
|
|
|
|
Unusual Query Error, Correlated Sub Query, Errors based how many records returned??