• x_japanfans5312 (6/24/2013)


    seems like the order BY Number DESC on the insert statement doesn;t work in SQL Server 2012

    We don't order INSERTS, we order SELECTS.

    Your two queries can be read like this:

    Add some rows into a table in a specific order.

    Give them back to me in any order.

    They should read like this:

    Add some rows into a table in any order.

    Give them back to me in a specific order.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]