Tsql - Use result from stored procedure in tsql script, capture it in a temporary table or variable

Post date: Feb 4, 2010 8:27:56 AM

DECLARE @tmp TABLE (

FirstName VARCHAR(100),

LastName VARCHAR(100)

)

INSERT @tmp (FirstName, LastName)

EXEC dbo.GetPersonByLastName @LastName = 'Henell'