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

  • February 5, 2018 at 8:07 am

    #1978554

    Why are you testing for both IsWeekend = 1 and weekdayno = 7?  If weekdayno = 7, then IsWeekend = 1 will always be true.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA