asked
Calculate "Expiration Date" Based on Date and Looked Up Value in MS SQL
I am creating an employee training tracking database. I have all of the training classes in a table along with the number of days said training is valid. (e.g. -[TrainingID],[TrainingName], [ExpirationDays]) I want to be able to have the expiration date automatically calculated when a user enters data into the training transactions table ([EmployeeID] foreign key, [TrainingID] foreign key, [TrainingDate] entered by user, [ExpirationDate] calculated based on [ExpirationDays] where TrainingID = currently entered TrainingID)
It would be best to wrap this logic in a stored procedure, where you pass in the user entered fields, and work out the values for the expiration date. Something along the lines of create proc InsertTraining ( @EmployeeID int, @TrainingID int, @TrainingDate datetime ) as set nocount on insert into TrainingTransactionTable (EmployeeID, TrainingID, TrainingDate, ExpirationDate) select @EmployeeID, @TrainingID, @TrainingDate, dateadd(day, [ExpirationDays], @TrainingDate) from Training where TrainingID = @TrainingID
9 People are following this question.
