Hi,I'm making some sort of application where people can add their resume.They also need something to add places where they have worked or currently are working.I have a form where they can add this and i add this experience using the following stored procedure:GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate procedure [dbo].[sp_Insert_Experience] @ExperienceId uniqueidentifier, @ExperienceEmployee nvarchar(100), @ExperienceFrom datetime, @ExperienceUntil datetime, @ExperienceQualifications nvarchar(250), @ExperienceTechnologies nvarchar(250), @ExperienceTasks nvarchar(250)as insert into Experiences values(@ExperienceId,@ExperienceEmployee,@ExperienceFrom,@ExperienceUntil,@ExperienceQualifications, @ExperienceTechnologies,@ExperienceTasks);
It must be possible to add the place where they currently are working. Then the ExperienceUntil has to be something like still going on. Then I decided that the user then had to set the current date. But what I want is the following, I want that the ExperienceUntil keeps updating automatically, like everytime i get that record, it has to have current date. Is this possible ?But if the ExperienceUntil isn't the current date , it just had to take the supplied parameter date.
Check if date is current date and stay current
Posted - 2008-04-25 : 09:19:16
