Home Forums SQL Server 2005 Development Inserting Multiple Records Using Range Numbers RE: Inserting Multiple Records Using Range Numbers
Paul White
SSC Guru
Points: 150467
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 WhiteSQLPerformance.comSQLkiwi blog@SQL_Kiwi