Dear Andy,

thank you for your response.

my stored procedure is given below:

*****************

create proc kb

@Name varchar(50)as

Set nocount on

declare @Code int

create table #Temp(Referer_ID int, Code int)

Select @Code = Code from Usr where Name...