I have a table called schedule that consists of 2 columns, start_date and end_date. I have entered values into the start_date column, but I need a function that will work out the end data based on parameters:
the start_date and the No of weeks (which is entered by the user). I need the function to be part of a insert function like this
create proc start_end@start_date
EXEC [insert schedule]@startdate
= start_date + w (where w = no weeks entered by the user)
Thanks, any suggestions would be greatly appreciated.