Home Forums SQL Server 2008 SQL Server Newbies Duplicating Data To Each Saturday That a Promotion Is Live For RE: Duplicating Data To Each Saturday That a Promotion Is Live For

  • thanks so much :

    CT_Prom_StartCT_Prom_EndPromo_Week_End
    4-Jan-1819-Jan-186-Jan-18
    4-Jan-1819-Jan-1813-Jan-18
    4-Jan-1819-Jan-1820-Jan-18
    3-Feb-1817-Feb-183-Feb-18

    its working for the first set where dates are 4-Jan 18 to 19 Jan 2018 but for the 03 Feb 18 - 18 Feb it is not , for this on it should duplicate to 03,10,17,24 Feb 2018,