Hi,
In a Stored PROC I have a query which retrieves value into a local variable.
Now the query has be converted into Dynamic.
This is causing a problem.
I am not able to retreive the value from dynamic query into variable.
Ex: Select @Variable=Name FROM Employee
The SELECT Clause needs to be converted into Dynamic,
and retreive the value into @Variable. Is This is Posssible in SQL2000?
NOTE: Retreiving the value into variable is important as it is used in other dynamic queries
Thanks and Regards
Chethan!!