Click here to Skip to main content
15,905,874 members
Home / Discussions / Database
   

Database

 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:38
phil241521-Aug-14 5:38 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
jschell15-Aug-14 9:39
jschell15-Aug-14 9:39 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:37
phil241521-Aug-14 5:37 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
PIEBALDconsult21-Aug-14 5:11
mvePIEBALDconsult21-Aug-14 5:11 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:20
phil241521-Aug-14 5:20 
Question(Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 21:45
Jassim Rahma11-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
Kornfeld Eliyahu Peter11-Aug-14 21:58
professionalKornfeld Eliyahu Peter11-Aug-14 21:58 
GeneralRe: (Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 23:40
Jassim Rahma11-Aug-14 23:40 
this solved my problem.

SQL
WHERE MONTH(contracts.expiry_date) = MONTH(DATE_ADD(DATE(NOW()), INTERVAL 1 MONTH)) AND YEAR(contracts.expiry_date) = YEAR(DATE_ADD(DATE(NOW()), INTERVAL 1 MONTH));


Thank you so much


Technology News @ www.JassimRahma.com

GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 1:42
professionalGuyThiebaut12-Aug-14 1:42 
GeneralRe: (Expiring Next Month) Problem Pin
Bernhard Hiller12-Aug-14 21:28
Bernhard Hiller12-Aug-14 21:28 
GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 21:45
professionalGuyThiebaut12-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
GuyThiebaut11-Aug-14 22:07
professionalGuyThiebaut11-Aug-14 22:07 
QuestionT-Sql Distribute data into groups based on existing numbers Pin
dreaddan10111-Aug-14 10:42
dreaddan10111-Aug-14 10:42 
AnswerRe: T-Sql Distribute data into groups based on existing numbers Pin
Jörgen Andersson13-Aug-14 22:44
professionalJörgen Andersson13-Aug-14 22:44 
QuestionProblem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd9-Aug-14 23:02
professionalVimalsoft(Pty) Ltd9-Aug-14 23:02 
AnswerRe: Problem with Decimal Places and Rounding off Pin
Kornfeld Eliyahu Peter10-Aug-14 0:00
professionalKornfeld Eliyahu Peter10-Aug-14 0:00 
GeneralRe: Problem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd10-Aug-14 1:28
professionalVimalsoft(Pty) Ltd10-Aug-14 1:28 
QuestionSelect and Update Pin
jkirkerx8-Aug-14 11:43
professionaljkirkerx8-Aug-14 11:43 
AnswerMy none soup version Pin
jkirkerx8-Aug-14 12:11
professionaljkirkerx8-Aug-14 12:11 
AnswerRe: Select and Update Pin
PIEBALDconsult8-Aug-14 20:57
mvePIEBALDconsult8-Aug-14 20:57 
Answer[Solved] Pin
jkirkerx10-Aug-14 12:50
professionaljkirkerx10-Aug-14 12:50 
AnswerRe: Select and Update Pin
MeutherOlaf11-Aug-14 20:36
MeutherOlaf11-Aug-14 20:36 
QuestionWeird problem with UNION query in Access 2010 Pin
Peter R. Fletcher8-Aug-14 3:46
Peter R. Fletcher8-Aug-14 3:46 
QuestionFind the right SSMS Pin
Corporal Agarn8-Aug-14 1:53
professionalCorporal Agarn8-Aug-14 1:53 
AnswerRe: Find the right SSMS Pin
Richard Deeming8-Aug-14 2:18
mveRichard Deeming8-Aug-14 2:18 

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.