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




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