Thanks a ton for reply, but i dun wanna use temp table. i knew it already

Hi

does sp_executeSql returns value, My query like this EXEC/Sp_executesql 'select emp_id form employee where emp_id=1'

I need That Emp_Id without using Temporary table