Hi,
Given a team id, i need to retrieve the list of members who are in that team.using stored procedure.
please give a suggestions.
given a team id, I need to retrieve the list of members
Loading
5 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Upendra Pratap ShahiPosted Aug 20, 2015, 3:02 AM
CREATE PROCEDURE usp_GetALLTeamMembers(@TeamID INT)
AS
BEGIN
SELECT m.MemberID,
m.MemberName,
m.MemberStatus,
ml.MemberLoginName,
tm.MemberJoinedDate,
tm.MemberLeftDate
FROM TeamMember tm
INNER JOIN MemberLogin ml
ON tm.MemberLoginID = ml.MemberLoginID
INNER JOIN Member m
ON m.MemberID = ml.MemberLoginID
WHERE tm.TeamID = @TeamID
END
Azeem AnzariPosted Aug 26, 2015, 1:00 PM
SivakumarPosted Aug 20, 2015, 7:49 AM
SivakumarPosted Aug 20, 2015, 6:56 AM
{
TeamMember getteammember = _DataContext.uspGetAllTeamMembers(teamid).SingleOrDefault();
return new TeamMemberData { TeamID = getteammember.TeamID, MemberLoginID = getteammember.MemberLoginID, MemberjoinedDate = getteammember.MemberJoinedDate };
}
please help me.
SivakumarPosted Aug 20, 2015, 2:49 AM
{
TeamMember GetTeamMember = _DataContext.usp_GetALLTeamMembers(teamid).SingleOrDefault();
return new TeamMemberData { TeamID=GetTeamMember.TeamID, MemberLoginID = GetTeamMember.MemberLoginID, MemberjoinedDate = GetTeamMember.MemberJoinedDate };