Home Forums SQL Server 2008 T-SQL (SS2K8) RANK ISSUE RE: RANK ISSUE

  • March 7, 2013 at 1:13 pm

    #1594673

    select

    ID = row_number() over (partition by TABLENAME order by COLNAME),

    TABLENAME,

    COLNAME

    from

    #temp;