Database

select  p.poke_id, s.[Name] as Poke_Giver_Name,s2.[Name] as Poke_Receiver_Name
from students s
inner join Poke p on p.Poke_Giver_Id = s.Student_Id
inner join students s2 on s2.Student_Id = p.Poke_Receiver_Id

Declare @Student table(StudentID int identity,Name varchar(20))
Declare @Poke table(Poke_Id int identity,Poke_Giver_Id int,Poke_Receiver_Id int)
insert into @Student values('Alex'),('Bob'),('Caveman')
insert into @Poke values(1,2),(1,2),(2,1)

Select x.Poke_Id,x.Poke_Giver_Name,Poke_Receiver_Name = s.Name
from(
	Select p.Poke_Id,s.Name Poke_Giver_Name ,p.Poke_Receiver_Id
	from @Poke p
	join @Student s
	on p.Poke_Giver_Id  = s.StudentID 
	)x
join @Student s on s.StudentID =x.Poke_Receiver_Id

/*

Poke_Id	Poke_Giver_Name	Poke_Receiver_Name
1	Alex	           Bob
2	Alex	           Bob
3	Bob	           Alex
*/

velmahesh wrote:

If this post is useful,

velmahesh wrote:

Please,Dont Forget to click   Accept Answer and Click vote.. Earn
Points.
 

Member 8003276 wrote:

ADD PRIMARY KEY (BatchID,StartTime)
 

ALTER TABLE BatchData
ADD CONSTRAINT PK_BatchData PRIMARY KEY (BatchID, StartTime);

SET @Command = 'DECLARE @voter_id INT SELECT @voter_id = voterid FROM tblCamp_CT WHERE ' + @Query
EXEC (@Command)

create table #Value (
val int 
)

set @command = 'insert into #value (val) SELECT top 1 voterid FROM tblCamp_CT WHERE ' +@Query

 exec(@command) 

set @voter_id=(select top 1 val from #Value)
delete #Value  

declare @voter_id int , @query varchar(max), @command nvarchar(4000) 
,@parm nvarchar(20) 
 
set @query='1=1'

SET @Command = 'SELECT top 1 @voter_id = voterid FROM tblCamp_CT WHERE ' + @Query
 
 
set @parm ='@voter_id int output '

  exec sp_executesql @command,@parm ,@voter_id out    
 
 select  @voter_id test 

PIEBALDconsult wrote:

That would be another reason not to use stored procedures

PIEBALDconsult wrote:

That would be another reason not to use
stored procedures. Things like that are so much simpler when the SQL is in your
DAL.

EXEC sp_executesql @DYNA_SQL, N'@NUM_ROWS int out'