>SET ENGINEBEHAVIOR 70
>first write the above statment in your procedure file or before query
>then execute the query

This is a very bad advice! The SQL engine was changed because the old behavior could give wrong results! The SET ENGINEBEHAVIOR command was added as a "band aid" so that the programmers could change the select statements one by one!!