Click here to Skip to main content
14,691,457 members
Home » Discussions » Database
   

Database

 
AnswerRe: SQL SERVER 2012 - pull data from only, if value date is available Pin
Richard MacCutchan27-Nov-18 1:31
mveRichard MacCutchan27-Nov-18 1:31 
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 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
Memberjoflo27-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
Memberjoflo27-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 
Why don't you use a sub-select for the date?
where (SaleDateFrom <= ( select max(your date column) from your table with date value ) and (SaleDateTo '20010101' or SaleDateTo is null ))

QuestionOnly begin select if value is found in dataset sql Pin
Joanna Webster16-Nov-18 5:31
MemberJoanna Webster16-Nov-18 5:31 
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
Memberjschell21-Nov-18 8:43 
QuestionCollecting data to make a excel graph Pin
Michael Clinton12-Nov-18 11:42
MemberMichael 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
professionalSimon_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
professionalSimon_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
professionalSimon_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
professionalSimon_Whale9-Nov-18 2:50 
QuestionConditional statements in ON clause of joins Pin
simpledeveloper7-Nov-18 13:49
Membersimpledeveloper7-Nov-18 13:49 

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.