Reterieving the result of dynamic query in a variable.

For this there are few tricks or the functionalities given by SQL.

1) Using a OUTPUT variable inside the dynamic query that sends the result of the dynamic query
2) Executing the query with sp_executesql function
3) Use of nVarchar type for cerating the dynamic query

The simple code goes as :

DECLARE @ValOut bigint



EXEC sp_executesql

   N'SELECT TOP 1 @outPutValue = memberid FROM as_tblmembers order  by 1 desc'

    ,N'@outPutValue bigint OUTPUT'

    ,@ValOut OUTPUT



SELECT @ValOut

Best Regards,
Puneet Sharma - Infosys
Pune, India