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 but at the moment my query is like (had to alter it
slightly
!
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 but at the moment my query is like (had to alter it
slightly
- 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 project for a
year. It gives 1 for these rows.
As a test idea, I
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 in that year.
The company I am doing this for, wants
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 in
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)
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 AM
Subject: Re: Year Lists
Martin,
Thanks