On Tuesday 27 December 2005 2:34 pm, Jesse wrote:
> I'm trying to write a trigger that will update the age of a camper when
> ever a record is updated or inserted. I have a table named Campers which
> contains basic information about the camper as well as their birthday. I
> have another table named Config which holds various settings, including the
> date at which camp begins. The Age field in the Campers table needs to be
> set based on the Config.CampStartDate. So, I have the following query that
> does what I need:
>
It seems to me that you're storing redundant data. If you know their
birthday, than you know their age, just subtract the birthday from today's
date and you have it.
--
Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar?
Fletch: I don't know. I don't have any.
Dr. Joseph Dolan: No children?
Fletch: No, elephant books.
