Dyanmic SQL in Stored Proc
I am trying to get a return value from dynamically created SQL statement in a stored procedure so that the stored procedure can determine how to proceed. Any ideas on how to do this??
EXAMPLE CODE:
--------------------
CREATE PROCEDURE st_addHistory (@record_id VARCHAR(50))AS
DECLARE @strSQL VARCHAR(1024)
SELECT @strSQL = 'SELECT somefield FROM tblSomething WHERE id = ' + @record_id
EXEC(@strSQL)
/*I need the Value from [somefield] here so I can see if it has a value*/
If somefield = 'Test1' DO THIS
...do some other stuff
GO
--------------------
END CODE
Thanks for any help,
Jake