Click here to Skip to main content
15,849,328 members
Home / Discussions / Database
   

Database

 
AnswerRe: Query Execution Time Management. Pin
Richard Deeming5-May-16 8:34
mveRichard Deeming5-May-16 8:34 
GeneralRe: Query Execution Time Management. Pin
Nasir Abbas5-May-16 20:41
Nasir Abbas5-May-16 20:41 
GeneralRe: Query Execution Time Management. Pin
Richard Deeming6-May-16 1:53
mveRichard Deeming6-May-16 1:53 
GeneralRe: Query Execution Time Management. Pin
Nasir Abbas9-May-16 0:32
Nasir Abbas9-May-16 0:32 
Questionaddition having null values in between Pin
Member 118403633-May-16 9:22
Member 118403633-May-16 9:22 
AnswerRe: addition having null values in between Pin
Tomas Takac3-May-16 9:59
Tomas Takac3-May-16 9:59 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 10:18
Member 118403633-May-16 10:18 
GeneralRe: addition having null values in between Pin
Tomas Takac3-May-16 10:51
Tomas Takac3-May-16 10:51 
Having a column per day is a poor design choice IMO. I'd strongly suggest you review it. As RyanDev already mentioned, you should use COALESCE[^], but you need to apply it to every value you are adding up.
SQL
COALESCE(1, 0) + COALESCE(2, 0) + ... + COALESCE(31, 0)

GeneralRe: addition having null values in between Pin
Member 118403633-May-16 16:03
Member 118403633-May-16 16:03 
AnswerRe: addition having null values in between Pin
ZurdoDev3-May-16 10:07
professionalZurdoDev3-May-16 10:07 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 10:32
Member 118403633-May-16 10:32 
AnswerRe: addition having null values in between Pin
ZurdoDev3-May-16 10:34
professionalZurdoDev3-May-16 10:34 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 10:42
Member 118403633-May-16 10:42 
GeneralRe: addition having null values in between Pin
ZurdoDev3-May-16 10:45
professionalZurdoDev3-May-16 10:45 
QuestionAlternatives to IBM DB2/Oracle? Pin
Member 1249383629-Apr-16 11:36
Member 1249383629-Apr-16 11:36 
AnswerRe: Alternatives to IBM DB2/Oracle? Pin
rick_lively30-Apr-16 11:40
rick_lively30-Apr-16 11:40 
NewsOmniDB - An Open Source Web Tool For Database Management and Conversion Pin
William Ivanski29-Apr-16 6:11
professionalWilliam Ivanski29-Apr-16 6:11 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Eddy Vluggen29-Apr-16 7:36
professionalEddy Vluggen29-Apr-16 7:36 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
William Ivanski29-Apr-16 7:52
professionalWilliam Ivanski29-Apr-16 7:52 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Eddy Vluggen29-Apr-16 8:21
professionalEddy Vluggen29-Apr-16 8:21 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Rafael T. Castro29-Apr-16 10:34
Rafael T. Castro29-Apr-16 10:34 
Questioni want to create data base by using c++ language Pin
Member 1249285029-Apr-16 1:01
Member 1249285029-Apr-16 1:01 
AnswerRe: i want to create data base by using c++ language Pin
Eddy Vluggen29-Apr-16 1:26
professionalEddy Vluggen29-Apr-16 1:26 
AnswerRe: i want to create data base by using c++ language Pin
ZurdoDev29-Apr-16 9:09
professionalZurdoDev29-Apr-16 9:09 
QuestionChange Data Capture is not capturing before value for the Images Pin
indian14327-Apr-16 12:17
indian14327-Apr-16 12:17 

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.