Database

d@nish wrote:

This one: *****

<Property Name="ContactGUID" Type="uniqueidentifier">

<Property Name="SectionGUID" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity">

declare @generated_keys table(ContactGUID uniqueidentifier)
insert [dbo].[dtblContact](surname, forname)
   output inserted.ContactGUID into @generated_keys
   values ('Blog', 'Joe')
select t.ContactGUID
   from @generated_keys as g 
   join [dbo].dtblContact as t on g.ContactGUID = t.ContactGUID 
   where @@ROWCOUNT > 0

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);