Home Forums SQL Server 2005 Development Inserting Multiple Records Using Range Numbers RE: Inserting Multiple Records Using Range Numbers
Paul White
SSC Guru
Points: 150468
More actions
June 24, 2009 at 9:08 am
#1014717
Hey Flo,
Nope - no difference at all, it just depends on my mood 🙂
ROW_NUMBER() OVER (ORDER BY (SELECT -42.7))
...works just as well.
Paul
Paul WhiteAll articles available on SQL.kiwi@SQL_Kiwi