Home Forums SQL Server 2008 T-SQL (SS2K8) Update sortorder column to +1 RE: Update sortorder column to +1

  • August 1, 2012 at 3:05 pm

    #1520547

    Lowell (8/1/2012)

    i think it's simply like this:

    ...ORDER BY ISNULL(SortOrder,2)

    yes it's simple if I have only one record to update but unfortunately I have thousands records like this 🙁