"Ankit Bhartia" <ankit.bhartia@cognizant.com> wrote in message
news:%23arltK$fHHA.1240@TK2MSFTNGP04.phx.gbl...
>
>
> I am facing a peculiar problem with dynamic sql query.
> I am using a dynamic query inside a SP. The query selects some data.
> Now, what I am doing is that,I am getting the query text using a "PRINT"
> and then trying to run it, I am getting the desired output. But when I
> try to run the same dynamically generated script from SP using "EXEC
> SP_EXECUTESQL" I am not getting any output. I am getting a empty
> resultset.
>
> Any suggestion, why am I facing this situation???
>
> *** Sent via Developersdex http://www.developersdex.com ***

..=2E@cognizant.com> wrote:
> I am facing a peculiar problem with dynamic sql query.
> I am using a dynamic query inside a SP. The query selects some data.
> Now, what I am doing is that,I am getting the query text using a "PRINT"
> and then trying to run it, I am getting the desired output. But when I
> try to run the same dynamically generated script from SP using "EXEC
> SP_EXECUTESQL" I am not getting any output. I am getting a empty
> resultset.
>
> Any suggestion, why am I facing this situation???
>
> *** Sent via Developersdexhttp://www.developersdex.com***