Click here to Skip to main content
15,511,378 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to get the Output based on Next Date if exists in the Table Pin
Mycroft Holmes10-Jun-14 0:01
professionalMycroft Holmes10-Jun-14 0:01 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Tim Carmichael10-Jun-14 3:49
Tim Carmichael10-Jun-14 3:49 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Bernhard Hiller10-Jun-14 21:56
Bernhard Hiller10-Jun-14 21:56 
QuestionManually increment a column value in SQL Server database through query when date < currentdate Pin
hilbiazhar9-Jun-14 21:08
hilbiazhar9-Jun-14 21:08 
AnswerRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Chris Quinn9-Jun-14 21:53
Chris Quinn9-Jun-14 21:53 
GeneralRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
hilbiazhar9-Jun-14 22:30
hilbiazhar9-Jun-14 22:30 
AnswerRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Chris Quinn9-Jun-14 22:04
Chris Quinn9-Jun-14 22:04 
AnswerRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Mycroft Holmes9-Jun-14 23:57
professionalMycroft Holmes9-Jun-14 23:57 
You avoided a nasty situation (and comment) by changing to date format in your database, ALWAYS store date in the correct format.

If you go down the path you describe, your are going to have to run the query EVERY day. As Chris suggested use a virtual computed column, I would use a view for this. Do not store the value, a view will automatically calc every time you access it.
Never underestimate the power of human stupidity
RAH

GeneralRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
hilbiazhar10-Jun-14 4:00
hilbiazhar10-Jun-14 4:00 
GeneralRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Chris Quinn10-Jun-14 5:02
Chris Quinn10-Jun-14 5:02 
QuestionRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Eddy Vluggen10-Jun-14 6:28
professionalEddy Vluggen10-Jun-14 6:28 
AnswerRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
hilbiazhar10-Jun-14 6:49
hilbiazhar10-Jun-14 6:49 
QuestionRegarding case control statement in mysql Pin
aghori9-Jun-14 4:15
aghori9-Jun-14 4:15 
AnswerRe: Regarding case control statement in mysql Pin
Wayne Gaylard9-Jun-14 4:22
professionalWayne Gaylard9-Jun-14 4:22 
GeneralRe: Regarding case control statement in mysql Pin
aghori9-Jun-14 4:34
aghori9-Jun-14 4:34 
AnswerRe: Regarding case control statement in mysql Pin
Jörgen Andersson9-Jun-14 4:25
professionalJörgen Andersson9-Jun-14 4:25 
GeneralRe: Regarding case control statement in mysql Pin
aghori9-Jun-14 4:37
aghori9-Jun-14 4:37 
Questiondatatype mapping Pin
Gilbert Consellado8-Jun-14 23:14
professionalGilbert Consellado8-Jun-14 23:14 
AnswerRe: datatype mapping Pin
Richard MacCutchan9-Jun-14 0:24
mveRichard MacCutchan9-Jun-14 0:24 
GeneralRe: datatype mapping Pin
Gilbert Consellado9-Jun-14 0:47
professionalGilbert Consellado9-Jun-14 0:47 
GeneralRe: datatype mapping Pin
Richard MacCutchan9-Jun-14 0:56
mveRichard MacCutchan9-Jun-14 0:56 
GeneralRe: datatype mapping Pin
Gilbert Consellado9-Jun-14 1:04
professionalGilbert Consellado9-Jun-14 1:04 
QuestionSQL Server and ADO.net IsolationLevel Pin
PIEBALDconsult6-Jun-14 17:10
professionalPIEBALDconsult6-Jun-14 17:10 
AnswerRe: SQL Server and ADO.net IsolationLevel Pin
Eddy Vluggen7-Jun-14 0:05
professionalEddy Vluggen7-Jun-14 0:05 
GeneralRe: SQL Server and ADO.net IsolationLevel Pin
PIEBALDconsult7-Jun-14 5:39
professionalPIEBALDconsult7-Jun-14 5:39 

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.