Hi, I have a stored procedure parameters are emp_no, avgsal.number
i have data in a table.my request is take emp_no from table and pass parameter to procedure .
For this one i want create a procedure and temp table.
ALTER procedure [dbo].[SalaryRetrivial] as begin declare @TSQL nvarchar(200) set @TSQL='select distinct emp_no from dbo.employee' Create Table #Temp ( avgsal int ,emp_no nvarchar(10) ) insert into #Temp ( avgsal, emp_no ) exec dbo.DebtScoreProcedure @TSQL,0,' ', select d.emp_no,d.emp_name,t.avgsal from dbo.employee d inner join #Temp t on d.emp_no=t.emp_no end GO
i got zero result when execte a procedure can you help on this please