Click here to Skip to main content
12,635,428 members (25,046 online)
   

Database

 
AnswerRe: Database updates Pin
Shameel14-Sep-12 2:31
memberShameel14-Sep-12 2:31 
GeneralRe: Database updates Pin
spankyleo12314-Sep-12 3:12
memberspankyleo12314-Sep-12 3:12 
AnswerUpdate with correlated sub query Pin
David Mujica14-Sep-12 4:16
memberDavid Mujica14-Sep-12 4:16 
GeneralRe: Update with correlated sub query Pin
spankyleo12314-Sep-12 4:43
memberspankyleo12314-Sep-12 4:43 
GeneralRe: Update with correlated sub query Pin
Jörgen Andersson14-Sep-12 9:55
memberJörgen Andersson14-Sep-12 9:55 
GeneralRe: Update with correlated sub query Pin
David Mujica15-Sep-12 16:11
memberDavid Mujica15-Sep-12 16:11 
GeneralRe: Update with correlated sub query Pin
Jörgen Andersson16-Sep-12 2:05
memberJörgen Andersson16-Sep-12 2:05 
QuestionSUM Problem in MSSQL Pin
Basak Oner12-Sep-12 0:41
memberBasak Oner12-Sep-12 0:41 
Hi everybody,
I have some numbers. Numbers are
(
0
234,9
-27
0
-55,9
0
0
-59
0
100,72
-26
0
-25,72
0
0
0
-82
0
0
0
0
0
0
-134)

I want to this.
SELECT SUM(FIELDX) FROM TBLX

but result is returning (-2,8421709430404007E-14)
actually resutl is 0 (Zero)
How can i solve this problem?

Thanks.

Başak Öner
AnswerRe: SUM Problem in MSSQL Pin
Eddy Vluggen12-Sep-12 1:16
memberEddy Vluggen12-Sep-12 1:16 
GeneralRe: SUM Problem in MSSQL Pin
Basak Oner12-Sep-12 1:27
memberBasak Oner12-Sep-12 1:27 
AnswerRe: SUM Problem in MSSQL Pin
Eddy Vluggen12-Sep-12 1:31
memberEddy Vluggen12-Sep-12 1:31 
AnswerRe: SUM Problem in MSSQL Pin
Basak Oner12-Sep-12 4:58
memberBasak Oner12-Sep-12 4:58 
GeneralRe: SUM Problem in MSSQL Pin
Eddy Vluggen12-Sep-12 7:00
memberEddy Vluggen12-Sep-12 7:00 
AnswerRe: SUM Problem in MSSQL Pin
Jörgen Andersson12-Sep-12 2:00
memberJörgen Andersson12-Sep-12 2:00 
QuestionSQL Seconds to Day, Hour, Minute, Second Pin
ahsansharjeel11-Sep-12 14:49
memberahsansharjeel11-Sep-12 14:49 
AnswerRe: SQL Seconds to Day, Hour, Minute, Second Pin
Mycroft Holmes11-Sep-12 15:24
memberMycroft Holmes11-Sep-12 15:24 
GeneralRe: SQL Seconds to Day, Hour, Minute, Second Pin
cbeglobal12-Sep-12 2:46
membercbeglobal12-Sep-12 2:46 
GeneralRe: SQL Seconds to Day, Hour, Minute, Second Pin
Mycroft Holmes12-Sep-12 13:36
memberMycroft Holmes12-Sep-12 13:36 
AnswerRe: SQL Seconds to Day, Hour, Minute, Second Pin
HiteshDR6-Nov-12 1:21
memberHiteshDR6-Nov-12 1:21 
QuestionTableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
lowhitaker10-Sep-12 12:15
memberlowhitaker10-Sep-12 12:15 
AnswerRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Mycroft Holmes10-Sep-12 15:19
memberMycroft Holmes10-Sep-12 15:19 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Jörgen Andersson11-Sep-12 1:37
memberJörgen Andersson11-Sep-12 1:37 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Mycroft Holmes11-Sep-12 2:10
memberMycroft Holmes11-Sep-12 2:10 
AnswerRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Michael Potter11-Sep-12 5:06
memberMichael Potter11-Sep-12 5:06 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
lowhitaker11-Sep-12 5:31
memberlowhitaker11-Sep-12 5:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 10 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid