Click here to Skip to main content
15,900,725 members
Home / Discussions / Database
   

Database

 
QuestionHelp required on Database Model Pin
Nitheesh George23-Feb-14 6:05
Nitheesh George23-Feb-14 6:05 
AnswerRe: Help required on Database Model Pin
Mycroft Holmes23-Feb-14 11:52
professionalMycroft Holmes23-Feb-14 11:52 
AnswerRe: Help required on Database Model Pin
Eddy Vluggen24-Feb-14 8:17
professionalEddy Vluggen24-Feb-14 8:17 
AnswerRe: Help required on Database Model Pin
Duncan Edwards Jones26-Feb-14 11:06
professionalDuncan Edwards Jones26-Feb-14 11:06 
Questionintricate date query sql Pin
Martin Niemandt19-Feb-14 22:07
Martin Niemandt19-Feb-14 22:07 
AnswerRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 22:19
mveRichard MacCutchan19-Feb-14 22:19 
GeneralRe: intricate date query sql Pin
Martin Niemandt19-Feb-14 22:28
Martin Niemandt19-Feb-14 22:28 
GeneralRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 23:08
mveRichard MacCutchan19-Feb-14 23:08 
Martin Niemandt wrote:
I absolutely have to display the date difference
Fine, but you should calculate it at the time you need to display it. Storing calculated values in the database is bad design and prone to error. I would suggest reading http://www.w3schools.com/sql/func_datediff.asp[^].
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:11
Martin Niemandt20-Feb-14 0:11 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:16
mveRichard MacCutchan20-Feb-14 0:16 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:24
Martin Niemandt20-Feb-14 0:24 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:29
mveRichard MacCutchan20-Feb-14 0:29 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:41
Martin Niemandt20-Feb-14 0:41 
AnswerRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 12:01
professionalMycroft Holmes20-Feb-14 12:01 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 18:53
Martin Niemandt20-Feb-14 18:53 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 19:46
professionalMycroft Holmes20-Feb-14 19:46 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 20:45
Martin Niemandt20-Feb-14 20:45 
GeneralRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 21:36
professionalMycroft Holmes20-Feb-14 21:36 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:01
Martin Niemandt20-Feb-14 22:01 
GeneralRe: intricate date query sql Pin
Jörgen Andersson20-Feb-14 21:28
professionalJörgen Andersson20-Feb-14 21:28 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:04
Martin Niemandt20-Feb-14 22:04 
QuestionMSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 19:26
Prasad A19-Feb-14 19:26 
AnswerRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 21:46
professionalGuyThiebaut19-Feb-14 21:46 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 22:08
Prasad A19-Feb-14 22:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 22:24
professionalGuyThiebaut19-Feb-14 22:24 

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.