Click here to Skip to main content
14,158,288 members
   

Database

 
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 
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
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 
GeneralRe: User Access Database - Best practise Pin
Simon_Whale9-Nov-18 1:50
professionalSimon_Whale9-Nov-18 1:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 12:49
membersimpledeveloper7-Nov-18 12:49 
AnswerRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes7-Nov-18 20:25
memberMycroft 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.


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190518.1 | Last Updated 23 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid