sample data is not possible , as it includes amny tables
yes row count is correct and time taken = 18 secs
but my concerns is UNION ALL with same tables
i want to replace it with correlated query.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)