You mean like this?
select rownumber() over(order by myidcol ASC) as newid,
idtest.*
from rob/idtest

NEWID MYIDCOL SOMECHAR
1 1 a
2 3 c

It's the "filename.*" you're looking for.


Rob Berendt




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