Posted by Wael on 05/22/06 20:11

Hi,
I have the following stored procedure that does some processing and
puts the result in a temporary table. I tried several things that
procedure to display output that I can access with ADO.Net, but it
doesn't work. It doesn't even display the result in the query analyzer
unless I add SELECT @ReturnFullName

Any help?

The stored procedure:
CREATE PROCEDURE sp_SEARCH_MULTIPLE_NAMES @search4fatherOf
varchar(255), @maximum_fathers int = 100, @ReturnFullName varchar(255)
Output

....

SELECT @ReturnFullName = name FROM #FULLNAME

------------------------------------------------
To Execute the stored procedure:
DECLARE @test varchar(255)
EXEC sp_SEARCH_MULTIPLE_NAMES @search4fatherof='مريم',
@returnfullname=@test
PRINT CONVERT(varchar(255), @test)

• Next in forum: Re: Returning multiple rows from a stored procedure
• Prev in forum: Re: Timeout errors
• Thread view: Returning multiple rows from a stored procedure

[Reply to this message]