I agree. You could just write

select so.* from SalesOrderdetail as so

and get the same result. (with the not null model)

That code...

I had come to this conclusion independently. It is nice to see collaboration.

One difference is that in my test case, the ROW_NUMBER was always faster even when properly indexed....

sql server 2008 express has import/export.

right-click on yourdatabasename, then click tasks