Error when using SUM function - 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

General SQL Server Forums

New to SQL Server Programming

Error when using SUM function

Author

Topic

dnyanubhamare
Starting Member

3 Posts

Posted - 2008-02-01 : 04:57:39

Hi,
I am write one storedprocedure,inside that i use sum function like
SUM((CASE WHEN d_end_name_qualifier LIKE 'Oc' THEN duration ELSE 0 END)) d_to_stream
then i get following error,

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

Connection Broken

Dnyaneshwar Bhamare

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-02-01 : 05:43:14

The error has nothing to do with SUM(). It may be that you are using SQL server hosted on one of Computer on LAN and your lan connection may have got disconnected or some other LAN or SQL Server problem.

dnyanubhamare
Starting Member

3 Posts

Posted - 2008-02-01 : 06:02:10

Hi,
My lan is working fine.
When i execute other functionality from same storedprocedure it work,
but when i execute SUM() function it gives error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

Dnyaneshwar Bhamare

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-02-01 : 06:09:18

What application you are working on i.e. front end. I don't see any reason why it should give this error? I too faced this error and reason(s) were same as mentioned in my previous post. I could provide more detail of SP you are using. May be it can help.

dnyanubhamare
Starting Member

3 Posts

Posted - 2008-02-01 : 06:55:19

Hi,
I use following SP
SELECT

SUM((CASE WHEN destination_end_name_qualifier LIKE 'OcFanout' THEN duration ELSE 0 END)) duration_to_fanout
FROM
Tangent.
This is my query.

Dnyaneshwar Bhamare

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-02-01 : 07:02:04

whilst there's nothing wrong with the query that would cause your error i'd question why you're using LIKE but not any wildcard operator? also, why the double brackets around your CASE?

Em

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources