Click here to Skip to main content
15,916,941 members
Home / Discussions / Database
   

Database

 
GeneralRe: Nested Select query Pin
andyharman26-Dec-07 23:33
professionalandyharman26-Dec-07 23:33 
GeneralRe: Nested Select query Pin
vimal_yet27-Dec-07 0:13
vimal_yet27-Dec-07 0:13 
QuestionDatabase Design Issue Pin
Mostafa Siraj26-Dec-07 19:57
Mostafa Siraj26-Dec-07 19:57 
GeneralRe: Database Design Issue Pin
vimal_yet27-Dec-07 0:18
vimal_yet27-Dec-07 0:18 
GeneralRe: Database Design Issue Pin
Colin Angus Mackay27-Dec-07 0:30
Colin Angus Mackay27-Dec-07 0:30 
GeneralRe: Database Design Issue Pin
Adeel Chaudhry27-Dec-07 20:50
Adeel Chaudhry27-Dec-07 20:50 
GeneralRe: Database Design Issue Pin
Paul Conrad28-Dec-07 10:25
professionalPaul Conrad28-Dec-07 10:25 
GeneralSelect statement Pin
tellytub26-Dec-07 16:13
tellytub26-Dec-07 16:13 
Hi all,

I'm currently doing a contract and supplier window form application.

I have this table (Contract) containing the following fields:

Contract_ID INT NOT NULL,
Vendor_ID INT NOT NULL,
DateStart datetime,
DateDue datetime,
PRIMARY KEY(Contract_ID),
FOREIGN KEY (Vendor_ID) REFERENCES Vendor(Vendor_ID)


I would like to do something like select contracts up for renewal in 3 months (my DateDue values range from 2004-04-16 to 2012-10-29).

I only know how to begin with the following:

SQL Select Statement:-
SELECT Contract_ID FROM Contracts WHERE DateDue... blahblahblah (can anyone guide me to continue?)

I am not sure that the above beginning statement is correct..

Any help is greatly appreciated. Thanks! Smile | :)

telly
GeneralRe: Select statement Pin
Krish - KP26-Dec-07 17:21
Krish - KP26-Dec-07 17:21 
AnswerRe: Select statement Pin
tellytub26-Dec-07 21:08
tellytub26-Dec-07 21:08 
Generaldoing function of search Pin
shufun26-Dec-07 14:29
shufun26-Dec-07 14:29 
GeneralI'm sure it is just a minor syntax error... Pin
Andy_L_J26-Dec-07 12:23
Andy_L_J26-Dec-07 12:23 
GeneralRe: I'm sure it is just a minor syntax error... Pin
J$26-Dec-07 13:08
J$26-Dec-07 13:08 
GeneralRe: I'm sure it is just a minor syntax error... Pin
Krish - KP26-Dec-07 17:11
Krish - KP26-Dec-07 17:11 
AnswerRe: I'm sure it is just a minor syntax error... Pin
Andy_L_J26-Dec-07 18:15
Andy_L_J26-Dec-07 18:15 
QuestionUsing avg function for new constructed column? Pin
omegazafer26-Dec-07 9:50
omegazafer26-Dec-07 9:50 
AnswerRe: Using avg function for new constructed column? Pin
Paul Conrad26-Dec-07 12:11
professionalPaul Conrad26-Dec-07 12:11 
AnswerRe: Using avg function for new constructed column? Pin
andyharman26-Dec-07 23:40
professionalandyharman26-Dec-07 23:40 
QuestionHow to encrypt? Pin
Rock Star.25-Dec-07 23:08
Rock Star.25-Dec-07 23:08 
AnswerRe: How to encrypt? Pin
Ujjaval Modi25-Dec-07 23:35
Ujjaval Modi25-Dec-07 23:35 
GeneralRe: How to encrypt? Pin
Rock Star.26-Dec-07 0:12
Rock Star.26-Dec-07 0:12 
AnswerRe: How to encrypt? Pin
Paul Conrad26-Dec-07 12:12
professionalPaul Conrad26-Dec-07 12:12 
Generalsql server 2000 stored procedure Pin
Sonia Gupta25-Dec-07 21:17
Sonia Gupta25-Dec-07 21:17 
GeneralRe: sql server 2000 stored procedure Pin
vimal_yet25-Dec-07 22:30
vimal_yet25-Dec-07 22:30 
GeneralRe: sql server 2000 stored procedure Pin
N a v a n e e t h25-Dec-07 23:15
N a v a n e e t h25-Dec-07 23:15 

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.