Hi there

I work in a SQL 2000 developer edition. when I run the provided script, it runs successfully returning rows 1 through 6.

Only if I run the script, without the from subselect, does it return a conversion error.

Why is that?

Marius