Click here to Skip to main content
14,145,240 members
   

Database

 
AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:13
memberMycroft Holmes28-Nov-18 13:13 
QuestionSQL SERVER 2012 - pull data from only, if value date is available Pin
joflo26-Nov-18 23:30
memberjoflo26-Nov-18 23:30 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 0:31
protectorRichard MacCutchan27-Nov-18 0:31 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 0:48
memberjoflo27-Nov-18 0:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 1:07
protectorRichard MacCutchan27-Nov-18 1:07 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 1:21
mveRichard Deeming27-Nov-18 1:21 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 1:48
memberjoflo27-Nov-18 1:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 2:12
mveRichard Deeming27-Nov-18 2:12 
And once again: If there are no records where the SaleDateFrom is on or before 1st November, then there will be no records where SaleDateFrom is on or before 31st October.

If there is a record for 31st October, then that will already be included in your current query.

If there are no records on or before 1st November, then changing your query to look for records with an earlier date isn't going to make any difference.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 2:18
memberjoflo27-Nov-18 2:18 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
James Walsh Jr1-Jan-19 9:09
professionalJames Walsh Jr1-Jan-19 9:09 
QuestionOnly begin select if value is found in dataset sql Pin
Joanna Webster16-Nov-18 4:31
memberJoanna Webster16-Nov-18 4:31 
AnswerRe: Only begin select if value is found in dataset sql Pin
Richard MacCutchan16-Nov-18 22:10
protectorRichard MacCutchan16-Nov-18 22:10 
AnswerRe: Only begin select if value is found in dataset sql Pin
jschell21-Nov-18 7:43
memberjschell21-Nov-18 7:43 
QuestionCollecting data to make a excel graph Pin
Michael Clinton12-Nov-18 10:42
memberMichael Clinton12-Nov-18 10:42 
AnswerRe: Collecting data to make a excel graph Pin
Mycroft Holmes13-Nov-18 11:12
memberMycroft Holmes13-Nov-18 11:12 
QuestionUser Access Database - Best practise Pin
Simon_Whale8-Nov-18 22:27
professionalSimon_Whale8-Nov-18 22:27 
AnswerRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 0:44
mveEddy Vluggen9-Nov-18 0:44 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:48
protectorJörgen Andersson9-Nov-18 0:48 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 0:57
mveEddy Vluggen9-Nov-18 0:57 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:59
protectorJörgen Andersson9-Nov-18 0:59 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:39
professionalSimon_Whale9-Nov-18 1:39 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 5:49
mveEddy Vluggen9-Nov-18 5:49 
AnswerRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:47
protectorJörgen Andersson9-Nov-18 0:47 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:38
professionalSimon_Whale9-Nov-18 1:38 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:46
protectorJörgen Andersson9-Nov-18 1:46 

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 | Cookies | Terms of Service
Web01 | 2.8.190518.1 | Last Updated 23 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid