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

Database

 
GeneralRe: ERD Help Pin
Prytol29-Nov-18 9:10
memberPrytol29-Nov-18 9:10 
AnswerRe: ERD Help Pin
Eddy Vluggen29-Nov-18 9:03
mveEddy Vluggen29-Nov-18 9:03 
QuestionWhat is the right database technology for this simple outlined BI tool use case? Pin
Member 1407009628-Nov-18 1:55
memberMember 1407009628-Nov-18 1:55 
AnswerRe: What is the right database technology for this simple outlined BI tool use case? Pin
Eddy Vluggen28-Nov-18 2:22
mveEddy Vluggen28-Nov-18 2:22 
GeneralRe: What is the right database technology for this simple outlined BI tool use case? Pin
Mycroft Holmes28-Nov-18 13:11
memberMycroft Holmes28-Nov-18 13:11 
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 
Hi
I wish to only begin a select statement if the top value date is found - this the first of the month. It's my way of knowing data has been added into a system at the beginning of the month e.g max date is 01/11/2018. If not take the last day of the previous month 31/10/2018. Table is called sales. Column is called SaleDateFrom.

I want to pull e.g data from SaleDateFrom <=01/11/2018...if not pull data
SaleDateFrom <=31/10/2018

statement to change

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

Any ideas team?
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 
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 

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.