Home Forums SQL Server 7,2000 T-SQL help me to select ROW_NUMBER in sql server 2000 RE: help me to select ROW_NUMBER in sql server 2000

  • April 7, 2011 at 10:29 am

    #1308664

    i usually just place what is needed into a temp table as below:

    select

    RowNumber = identity(int,1,1)

    ,Column_1

    ,Column_2

    into #im_temp0

    from <tableName>