sql - Insert record into table in stored procedure -

i using sql server 2012

i need insert prdate udemp table base on prco, employee , job. have 2 parameters @begdate , @enddate, example original record table like

@begdate '07/27/2014' @enddate '08/10/2014'   select co, job, employee  udemp 

i need code result this

the prdate sunday start begdate , end in enddate. think cursor may can it, how not figure out. please help. thank

you don't need cursor. simple recursive cte solves problem:

with dates (       select cast(@begdate date) thedate       union       select dateadd(day, 7, thedate)       dates       thedate < @enddate      ) select e.co, e.job, e.employee, dates.thedate prdate udemp e cross join      dates; 

this easy enough adapt insert if need.