Click here to Skip to main content
15,867,771 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 0:48
joflo27-Nov-18 0:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 1:07
mveRichard 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
joflo27-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
joflo27-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
Joanna Webster16-Nov-18 4:31 
Hi
I wish to only begin a select statement if the top value date is found. 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/01/2018. If not take the last day of the month 31/10/2018. Table is called sales. Column is called SaleDateFrom.

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

Any ideas team?
AnswerRe: Only begin select if value is found in dataset sql Pin
Richard MacCutchan16-Nov-18 22:10
mveRichard MacCutchan16-Nov-18 22:10 
AnswerRe: Only begin select if value is found in dataset sql Pin
jschell21-Nov-18 7:43
jschell21-Nov-18 7:43 
QuestionCollecting data to make a excel graph Pin
Michael Clinton12-Nov-18 10:42
Michael Clinton12-Nov-18 10:42 
AnswerRe: Collecting data to make a excel graph Pin
Mycroft Holmes13-Nov-18 11:12
professionalMycroft Holmes13-Nov-18 11:12 
QuestionUser Access Database - Best practise Pin
Simon_Whale8-Nov-18 22:27
Simon_Whale8-Nov-18 22:27 
AnswerRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 0:44
professionalEddy Vluggen9-Nov-18 0:44 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:48
professionalJörgen Andersson9-Nov-18 0:48 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 0:57
professionalEddy Vluggen9-Nov-18 0:57 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:59
professionalJörgen Andersson9-Nov-18 0:59 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:39
Simon_Whale9-Nov-18 1:39 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 5:49
professionalEddy Vluggen9-Nov-18 5:49 
AnswerRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 0:47
professionalJörgen Andersson9-Nov-18 0:47 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:38
Simon_Whale9-Nov-18 1:38 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:46
professionalJörgen Andersson9-Nov-18 1:46 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:50
Simon_Whale9-Nov-18 1:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 12:49
simpledeveloper7-Nov-18 12:49 
AnswerRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes7-Nov-18 20:25
professionalMycroft Holmes7-Nov-18 20:25 

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.