Here is something interesting....

If I take the same query and make it into a view, it comes back in a second. If I run the view query into a...

All indexes match up to the old sql 2000 server. I thought the same thing about the UDF, so I created a new one just to return the same...