Create Table Test(Id int identity,EmpId Int,EName nvarchar(100))
Insert into Test values(1,'a')
Insert into Test values(2,'b')
Insert into Test values(3,'c')
Insert into Test values(4,'d')
Insert into Test values(5,'z')
Alter Proc GetResult
as
Begin
Declare @Tbl1 Table (Id int Identity,Empid int)
Declare @Tbl2 Table (Id int Identity,Empname nvarchar(100))
Insert into @Tbl1 Select EmpID from Test Order by 1 desc
Insert into @Tbl2 Select EName from Test Order by 1
Select Empid,Empname from @Tbl1 T1,@Tbl2 T2 where T1.Id=T2.Id
End