• Simply add an IDENTITY column to your table (if you haven't one already).

    Give each row the same value for OrderDate: 2013-07-04. Then simply distract the identity value from the OrderDate to get the required values for your OrderDate column.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP