I have a table with 4 fields, Startdate, rec_num , recursive_value, recursive_date 04/02/2014 3 d 04/02/201404/02/2014 3 d 04/02/201404/02/2014 3 d 04/02/2014I will like to update recursive_date to emulate the recursive_number and recursive_value fields which specify every 3 days. The recursive_value field can also be w to specify weeks, m to specify month or y to specify years.So my value in the recursive_date field should be updated as followed

select Startdate, rec_number , recursive_value*number, dateadd(day,recursive_value*number,recursive_date) from your_table as t cross join master..spt_values where type='p' and number between 0 and (select count(*) from your_table)-1

I have a table with 4 fields,Startdate, rec_num , recursive_value, recursive_date04/02/2014 3 d 04/02/201404/02/2014 3 d 04/02/201404/02/2014 3 d 04/02/2014I will like to update recursive_date to emulate the recursive_number and recursive_value fields which specify every 3 days. The recursive_value field can also be w to specify weeks, m to specify month or y to specify years.So my value in the recursive_date field should be updated as followed

but i would also like to specify a end date so if i chosen startdate = 01/01/2014 and the chosen enddate = 03/29/2014, (rec_number = which is every 3 days), (recursive_value, which is days) i would like all the days every 3 days from the startdate to the enddate. as it is right now i have a recurrence count value...which specify i.e startdate, rec_number, recursive_value and how many times i want this to occur so i can pick 6 times. I would like to pick enddate.