Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    6

    Unanswered: ASE 15.5 Row Number Question

    Hello,

    Does ASE 15.5 support "Row_Number() over" clause as SQL Server?
    If not is there any alternative for doing similar function in ASE. Many Thanks.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Insert into temp table with identity column

  3. #3
    Join Date
    Apr 2011
    Posts
    6
    Thanks Pdreyer,

    Do you know the syntax of select identity into a temp table in ASE?

    e.g. select identity(1) as 'ROWID' , * into #tmp from #table

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    select ROWID=identity(int), * into #tmp from ...

  5. #5
    Join Date
    Apr 2011
    Posts
    6
    Many Thanks pdreyer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •