Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gpc44
Starting Member
35 Posts |
 Posted - 2014-07-04 : 09:45:49
|
I have this Date Values ??(DateFrom, DateUntil) selected, which lie in the current Date Range - or in the future.Now I would like to have:- If getdate () between Date From and DateUntil, then take this.- If there is only future values??, then take the most obvious diagnosis suggests most value.---------------------------------DateFrom DateUtil2011-09-01 2014-08-312014-09-01 2014-10-312014-11-01 2015-06-302015-07-01 NULL----------------------------------RegardsNicole  |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-07-07 : 15:59:17
|
quote:
Originally posted by gpc44
- If there is only future values??, then take the most obvious diagnosis suggests most value.
What does that mean? What's an "obvious diagnosis" in the context of your question? |
 |
|
|
|
|
|
Get Record in Date-Range