nzhang6666 (9/5/2012)
Just found out. The compatible level of the database is set to sql server 2000 (8.0).I didn't know function can not be used in parameters of a table valued function in 2000...
But I can run a query with recursive CTE on the database, does 2000 supports CTE?
best way to find out is to try it yourself...but no, CTE's will not work in 2000/ 80 compatibility...you have to change it to subqueries.
Lowell