Thanx.

The return 0 or 1 approach will work, though it's still not a perfect solution, but I will prefer it than Union All. 🙂

By the way, there's another 2 things...

I thought of Union All before. But I am not sure whether it supports Cursor, actually I am using this select statement as a cursor to walk though records, and...

Thanks, Greg,

Again, I don't like the work around you provided. sorry. 🙂

Actually I was using the first approach you...

Yes, The proposal will work but I don't like the code, it looks like cumbersome.

Especially, my condition is much more complex than this, which will make my code ugly...

Yes, The proposal will work but I don't like the code, it looks like cumbersome.

Especially, my condition is much more complex than this, which will make my code ugly...

I hate Temporary table, because it caused a lot of problems, besides performance problems.

Maybe I should avoid Dynamic SQL. But sometimes, it's a pain without using a Dynmic SQL, especially...

Yes, you are right, the proposed solution won't enable you to access the @table.

Looks like I still have to use Temporary table in order to access the result of a...