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'