You need something in the over(). Something in the parenthesis. One
sample is
select rownumber() over(order by myidcol ASC) as newid,
idtest.*
from rob/idtest



Rob Berendt

This thread ...

Follow-Ups:
Replies:


Return to Archive home page | Return to MIDRANGE.COM home page