Re: Year Lists

2003-01-02 Thread Nicholas Elliott
luck =] Nick Elliott - Original Message - From: "Steve Vernon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 02, 2003 8:53 AM Subject: Re: Year Lists > Thanks for the email... > > Brilliant idea, but it does not give 0 for rows without a proje

Re: Year Lists

2003-01-02 Thread Paul DuBois
ssly inefficient! Nick Elliott - Original Message - From: "Steve Vernon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 31, 2002 10:44 AM Subject: Re: Year Lists > Martin, > Thanks for the reply. > > Good plan b

Re: Year Lists

2003-01-02 Thread Steve Vernon
But don't blame me if the query is grossly inefficient! > > Nick Elliott > > - Original Message - > From: "Steve Vernon" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 31, 2002 10:44 AM > Subject: Re: Year Lists > >

Re: Year Lists

2002-12-31 Thread Nicholas Elliott
f 0 for any years without a project (Almost 100% certain =] ). But don't blame me if the query is grossly inefficient! Nick Elliott - Original Message - From: "Steve Vernon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 31, 2002 10:44

Re: Year Lists

2002-12-31 Thread Steve Vernon
Martin, Thanks for the reply. Good plan but at the moment my query is like (had to alter it slightly as it was in PHP and multiple lines, so dont take it as working). SELECT projects.name, project.endyear, project.startyear FROM projects WHERE projects.startyear <= '(INPUT THE YEAR HERE)

Re: Year Lists

2002-12-31 Thread Martin Waite
On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: > Hiya, > I have a database about projects in a company, they all have a start > year and end year. If the projects have not ended then they get a end year > of . I have made a SQL command, given a year, works out with projects > are running