• Very well written, a nice article.

    Can you please put some light on the excution plan of this SP, while writing dynamic SQL.

    As per knowledged, the execution plan won't be resued.

    Please suggest.