Click here to Skip to main content
14,239,046 members
   

Database

 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 23:30
mveEddy Vluggen28-Nov-18 23:30 
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 
I'm doing my best to explain ,

here is my where clause

where (SaleDateFrom<= '20181101'
and (SaleDateTo '20010101' or
SaleDateTo is null))

I want to replace the date in bold to 20181031 if the highest date entered into the data base is not the 20181101. this is to make sure the data for the start of the month has been entered


please help



please see response to Richard - about account big issue, which I be contacting code project about
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 
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 

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.