Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
trouble2
Constraint Violating Yak Guru
267 Posts |
 Posted - 2010-12-16 : 08:08:52
|
| I'm trying to do this, but I guess the code is to new for SQL 2000, so what should I change:SELECT row_number() over (order by MAX(HeadlineDate)) as Number,The secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
row_number