Home Forums SQL Server 2005 Development Reset the Number by Column Value using ROW_NUMBER() OVER (PARTITION BY Field) RE: Reset the Number by Column Value using ROW_NUMBER() OVER (PARTITION BY Field)

  • Thanks Lowell for instant reply,

    This is my predication, not the actual data

    , actual data is differ from my Example

    in my data it gives me lot of no's 1,2,3.......n or sometime it gives only 2, 3 no's

    in such case i cant specify the RowId.

    any other technique on the same query.

    Thanks once again.

    Patel Mohamad