You are rite David,

Thanks for reply

I have to replace one very complex table function join condition llisted as below,

{ JOIN TABLE A B C query part }

Where XYZ=...

To Whoever Replyed,

This is sample of data,actual table has 1 million row.

Query should be something like

select ano from #x1 where Dept in ('A1','A5','A6')

And Output should be the "list of...