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
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
Azeem AnzariPosted Aug 28, 2015, 8:03 PM
Azeem AnzariPosted Aug 28, 2015, 2:50 AM
Join Team t on t.TeamID= tm.TeamID
join Member m on ml.MemberID= m.MemberID
where m.MemberID=@MemberID and t.TeamStatus='1'
SivakumarPosted Aug 28, 2015, 2:39 AM
Azeem AnzariPosted Aug 28, 2015, 2:38 AM
SivakumarPosted Aug 28, 2015, 2:18 AM
SivakumarPosted Aug 28, 2015, 2:15 AM
Azeem AnzariPosted Aug 28, 2015, 2:13 AM