The JPG of the new query plans do not show that the problem was solved. It actually made it worst because the static version now shows both 2008 and...

-- Below is a test case for you to confirm the raised issue about the query plan and paramterized value with check constraint.

-- Here is some code to create 3...

I need to be able to do this both ways in SQL 7 which I have now and SQL 2000 which will be installed in the next month.

Thanks

Colby