Click here to Skip to main content
11,648,785 members (83,135 online)
   

Database

 
AnswerRe: Database updates Pin
Shameel14-Sep-12 1:31
memberShameel14-Sep-12 1:31 
GeneralRe: Database updates Pin
spankyleo12314-Sep-12 2:12
memberspankyleo12314-Sep-12 2:12 
AnswerUpdate with correlated sub query Pin
David Mujica14-Sep-12 3:16
memberDavid Mujica14-Sep-12 3:16 
GeneralRe: Update with correlated sub query Pin
spankyleo12314-Sep-12 3:43
memberspankyleo12314-Sep-12 3:43 
GeneralRe: Update with correlated sub query Pin
Jörgen Andersson14-Sep-12 8:55
memberJörgen Andersson14-Sep-12 8:55 
GeneralRe: Update with correlated sub query Pin
David Mujica15-Sep-12 15:11
memberDavid Mujica15-Sep-12 15:11 
GeneralRe: Update with correlated sub query Pin
Jörgen Andersson16-Sep-12 1:05
memberJörgen Andersson16-Sep-12 1:05 
QuestionSUM Problem in MSSQL Pin
Basak Oner11-Sep-12 23:41
memberBasak Oner11-Sep-12 23: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 0:16
memberEddy Vluggen12-Sep-12 0:16 
GeneralRe: SUM Problem in MSSQL Pin
Basak Oner12-Sep-12 0:27
memberBasak Oner12-Sep-12 0:27 
AnswerRe: SUM Problem in MSSQL Pin
Eddy Vluggen12-Sep-12 0:31
memberEddy Vluggen12-Sep-12 0:31 
AnswerRe: SUM Problem in MSSQL Pin
Basak Oner12-Sep-12 3:58
memberBasak Oner12-Sep-12 3:58 
GeneralRe: SUM Problem in MSSQL Pin
Eddy Vluggen12-Sep-12 6:00
memberEddy Vluggen12-Sep-12 6:00 
AnswerRe: SUM Problem in MSSQL Pin
Jörgen Andersson12-Sep-12 1:00
memberJörgen Andersson12-Sep-12 1:00 
QuestionSQL Seconds to Day, Hour, Minute, Second Pin
ahsansharjeel11-Sep-12 13:49
memberahsansharjeel11-Sep-12 13:49 
AnswerRe: SQL Seconds to Day, Hour, Minute, Second Pin
Mycroft Holmes11-Sep-12 14:24
memberMycroft Holmes11-Sep-12 14:24 
GeneralRe: SQL Seconds to Day, Hour, Minute, Second Pin
cbeglobal12-Sep-12 1:46
membercbeglobal12-Sep-12 1:46 
GeneralRe: SQL Seconds to Day, Hour, Minute, Second Pin
Mycroft Holmes12-Sep-12 12:36
memberMycroft Holmes12-Sep-12 12:36 
AnswerRe: SQL Seconds to Day, Hour, Minute, Second Pin
HiteshDR6-Nov-12 0:21
memberHiteshDR6-Nov-12 0:21 
QuestionTableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
lowhitaker10-Sep-12 11:15
memberlowhitaker10-Sep-12 11:15 
AnswerRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Mycroft Holmes10-Sep-12 14:19
memberMycroft Holmes10-Sep-12 14:19 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Jörgen Andersson11-Sep-12 0:37
memberJörgen Andersson11-Sep-12 0:37 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Mycroft Holmes11-Sep-12 1:10
memberMycroft Holmes11-Sep-12 1:10 
AnswerRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
Michael Potter11-Sep-12 4:06
memberMichael Potter11-Sep-12 4:06 
GeneralRe: TableAdapters results differ from Stored Procedure results, C# - SQL 2000 Pin
lowhitaker11-Sep-12 4:31
memberlowhitaker11-Sep-12 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.150804.4 | Last Updated 4 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid