try something like
ALTER PROCEDURE [dbo].[InsertProfile]
@Full_Name nvarchar(50),
@Add nvarchar(50),
@M_Num bigint,
@Mail_ID nvarchar(50),
@B_Group nvarchar(50),
@EmpID bigint OUTPUT
CREATE TABLE #tempSubscriber
(
ID INT,
[EMPNAME] nvarchar(50)
}
AS
Insert Into dbo.EmployeeData
(
FullName,
Address,
MobileNumber,
EmailID,
BloodGroup
)
Values
(
@Full_Name,
@Add,
@M_Num,
@Mail_ID,
@B_Group
)
INSERT INTO #tempSubscriber
(ID,[EMPNAME]) VALUES (SCOPE_IDENTITY(),@Full_Name)
Select * FROM #tempSubscriber
Here you need to create a #Table (HASHTABLE)