Help on performance with dynamic query

You need to analyze the execution plan for that and see costly steps

With your explanation alone its not enough for us to suggest much on performance.

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page