Sivakumar

Sivakumar

  • NA
  • 551
  • 217.8k

Iam Getting duplicate values from stored procedure

Aug 28 2015 1:55 AM
Hi,
 
I'm Getting Duplicate values from stored procedure,
this is my table structure :
 
 
and this is my stored procedure :
 
ALTER PROCEDURE [dbo].[uspGetAllMemberTeam](@MemberID INT)

AS

BEGIN


select t.TeamName,t.TeamID,t.TeamStatus, m.MemberName from TeamMember tm join MemberLogin ml on tm.MemberLoginID=ml.MemberLoginID
Join Team t on t.TeamID= tm.TeamID
join Member m on ml.MemberID= m.MemberID
where m.MemberID=@MemberID and t.TeamStatus='1'

END
but am executing stored procedure getting duplicate values like TeamID, TeamName 
 
in MemberLogin table i enter the MemberID '1' two columns so getting duplicate values 
 
please give a help

Answers (7)