Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
Iam Getting duplicate values from stored procedure
Sivakumar
Aug 28 2015 1:55 AM
355
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Displaying gestures in XML!
how to delete files in a folder based on date modification