Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: working with dates

    I believe you are looking for something like this

    CREATE TABLE #MyProductDates(Product VARCHAR(30), FridayDate DATE, MondayDate DATE)

    INSERT INTO #MyProductDates(Product, FridayDate, MondayDate)

    SELECT 'ABC' , '2012-06-15' , '2012-06-18'

    UNION ALL

    SELECT 'ABC' , '2012-06-22',...

Viewing post 1 (of 2 total)