Home Forums SQL Server 2014 Development - SQL Server 2014 How Do I ? Batching the data RE: How Do I ? Batching the data

  • July 6, 2015 at 1:25 am

    #1810361

    Something like this?

    SELECT x.id

    , DENSE_RANK() OVER (ORDER BY x.id) as DenseRnk

    FROM

    (SELECT 'A123' AS ID

    UNION ALL

    SELECT 'A124'

    UNION ALL

    SELECT 'A124'

    UNION ALL

    SELECT 'A123'

    UNION ALL

    SELECT 'A127') x

    And then do like Phil said and join back to the original table to show where to put each item?