>Hi
>You can refer to this link
>
>http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/7e5e08d0-2ef3-4858-b4cf-c73541edc178
>
>Thank you


The issue is Table Spool step.

define view with UNION ALL
and try

query syntax OPTION (FORCE ORDER)