Use of multiple Applymap statements instead of Joins

[rsdhavle]

I have one scenario where I can achieve result by using self join for 7-8 times on one of the table. If I achieve same results by using multiple ApplyMap statements that is double than the number of Joins. Around 14-16 applymap statements as I need to get 2 columns from table 2 based on the key column.

What is the better solution considering performance?

[MK_QSL]

It all depends on data and relationship between them.

Without actually working on this, can't decide.

You can use both of them and try to find out which one is giving you better script time.

Of course, the end result must be same for both of these.

[rsdhavle]

yes end result is same..reload time reduced a bit when I used applymap but somehow I am not able to judge performance at this point of time as I only have a single table in the report at the moment