Click here to Skip to main content
15,789,776 members
Home / Discussions / Database
   

Database

 
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 MacCutchan27-Nov-18 2:07
mveRichard MacCutchan27-Nov-18 2:07 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 2:21
mveRichard Deeming27-Nov-18 2:21 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 2:48
joflo27-Nov-18 2:48 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard Deeming27-Nov-18 3:12
mveRichard Deeming27-Nov-18 3:12 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
joflo27-Nov-18 3:18
joflo27-Nov-18 3:18 
GeneralRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
James Walsh Jr1-Jan-19 10:09
professionalJames Walsh Jr1-Jan-19 10:09 
QuestionOnly begin select if value is found in dataset sql Pin
Joanna Webster16-Nov-18 5:31
Joanna Webster16-Nov-18 5: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 23:10
mveRichard MacCutchan16-Nov-18 23:10 
AnswerRe: Only begin select if value is found in dataset sql Pin
jschell21-Nov-18 8:43
jschell21-Nov-18 8:43 
QuestionCollecting data to make a excel graph Pin
Michael Clinton12-Nov-18 11:42
Michael Clinton12-Nov-18 11:42 
AnswerRe: Collecting data to make a excel graph Pin
Mycroft Holmes13-Nov-18 12:12
professionalMycroft Holmes13-Nov-18 12:12 
QuestionUser Access Database - Best practise Pin
Simon_Whale8-Nov-18 23:27
Simon_Whale8-Nov-18 23:27 
AnswerRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 1:44
professionalEddy Vluggen9-Nov-18 1:44 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:48
professionalJörgen Andersson9-Nov-18 1:48 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 1:57
professionalEddy Vluggen9-Nov-18 1:57 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:59
professionalJörgen Andersson9-Nov-18 1:59 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:39
Simon_Whale9-Nov-18 2:39 
GeneralRe: User Access Database - Best practise Pin
Eddy Vluggen9-Nov-18 6:49
professionalEddy Vluggen9-Nov-18 6:49 
AnswerRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 1:47
professionalJörgen Andersson9-Nov-18 1:47 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:38
Simon_Whale9-Nov-18 2:38 
GeneralRe: User Access Database - Best practise Pin
Jörgen Andersson9-Nov-18 2:46
professionalJörgen Andersson9-Nov-18 2:46 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 2:50
Simon_Whale9-Nov-18 2:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 13:49
simpledeveloper7-Nov-18 13:49 
AnswerRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes7-Nov-18 21:25
professionalMycroft Holmes7-Nov-18 21: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.