Thanks for the detailed response!!

Thanks for the response.

Heres another one. Using CTE I undestand we dont have to worry about storing and retrieving from tempdb. It works as we have the USING Stmts....

Hi I use lot of merge in my SPs. Never noticed performance issue. If you can provide substantial evi it will great