Retrieving Values From Dynamic SQL

Anyone know if it's possible to retrieve a parameterized value from dynamically executed SQL???





Code Example





Declare @table varchar(25)


Declare @somevalue varchar(3)


Set @table = 'sometable'


Set @somevalue = 'somevalue'





Declare @sqlBuild varchar(2000)





Set @sqlBuild = 'DECLARE @return varchar(3); ' +


' SELECT @return = COUNT(COLUMNAME) ' +


' FROM ' + @table +


' WHERE ' +


' value = ' + @somevalue


exec (@sqlBuild)








i want to be able to extract the value of @return for later use. this procdure works fine but I need to grab that value somehow.





Any suggestions?