Click here to Skip to main content
14,635,647 members
Home » Discussions » Database
   

Database

 
AnswerRe: set password on database in sql server 2005 Pin
Shameel22-Jul-11 9:19
professionalShameel22-Jul-11 9:19 
QuestionEntity Framework and Default Values [answered] Pin
Pascal Ganaye21-Jul-11 6:33
MemberPascal Ganaye21-Jul-11 6:33 
AnswerRe: Entity Framework and Default Values [answer] Pin
Pascal Ganaye21-Jul-11 22:05
MemberPascal Ganaye21-Jul-11 22:05 
QuestionHow to do a select statement from two or more tables? Pin
eight20-Jul-11 23:27
Membereight20-Jul-11 23:27 
AnswerRe: How to do a select statement from two or more tables? Pin
Blue_Boy20-Jul-11 23:43
MemberBlue_Boy20-Jul-11 23:43 
GeneralRe: How to do a select statement from two or more tables? Pin
eight20-Jul-11 23:51
Membereight20-Jul-11 23:51 
GeneralRe: How to do a select statement from two or more tables? Pin
Blue_Boy21-Jul-11 0:58
MemberBlue_Boy21-Jul-11 0:58 
AnswerRe: How to do a select statement from two or more tables? Pin
Niladri_Biswas24-Jul-11 22:26
MemberNiladri_Biswas24-Jul-11 22:26 
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
*/

Niladri Biswas

General:-\ Select Pin
velmahesh20-Jul-11 18:22
Membervelmahesh20-Jul-11 18:22 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Mycroft Holmes20-Jul-11 20:51
professionalMycroft Holmes20-Jul-11 20:51 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy20-Jul-11 21:25
MemberBlue_Boy20-Jul-11 21:25 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Shameel21-Jul-11 2:29
professionalShameel21-Jul-11 2:29 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy21-Jul-11 2:44
MemberBlue_Boy21-Jul-11 2:44 
AnswerRe: What is Buffer Pool in SqlServer? Pin
PIEBALDconsult21-Jul-11 2:45
professionalPIEBALDconsult21-Jul-11 2:45 
QuestionSSRS 2005 Sub report issue (newbie) Pin
Paul E Davies19-Jul-11 1:07
MemberPaul E Davies19-Jul-11 1:07 
AnswerRe: SSRS 2005 Sub report issue (newbie) Pin
Paul E Davies21-Jul-11 0:27
MemberPaul E Davies21-Jul-11 0:27 
QuestionSQL Syntax Issue Pin
Frank Lepkowski18-Jul-11 3:04
MemberFrank Lepkowski18-Jul-11 3:04 
AnswerRe: SQL Syntax Issue Pin
Tim Carmichael18-Jul-11 3:13
MemberTim Carmichael18-Jul-11 3:13 
AnswerRe: SQL Syntax Issue Pin
AnnieMacD18-Jul-11 3:38
MemberAnnieMacD18-Jul-11 3:38 
QuestionDynamic Query Question Pin
Kevin Marois14-Jul-11 19:01
professionalKevin Marois14-Jul-11 19:01 
AnswerRe: Dynamic Query Question Pin
Blue_Boy14-Jul-11 20:54
MemberBlue_Boy14-Jul-11 20:54 
GeneralRe: Dynamic Query Question Pin
Kevin Marois15-Jul-11 5:34
professionalKevin Marois15-Jul-11 5:34 
GeneralRe: Dynamic Query Question Pin
smcnulty200015-Jul-11 22:31
Membersmcnulty200015-Jul-11 22:31 
AnswerRe: Dynamic Query Question Pin
smcnulty200014-Jul-11 21:53
Membersmcnulty200014-Jul-11 21:53 
AnswerRe: Dynamic Query Question Pin
dasblinkenlight15-Jul-11 17:00
Memberdasblinkenlight15-Jul-11 17:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.