Hi,
this is my table structure :
and this is my stored procedure :
ALTER PROCEDURE [dbo].[uspGetAllTeamMembers](@TeamID INT)
AS
BEGIN
SELECT
tm.TeamID,
m.MemberID,
m.MemberName,
m.MemberStatus,
ml.MemberLoginName,
ml.MemberLoginID,
tm.MemberJoinedDate,
tm.MemberLeftDate
FROM TeamMember tm
INNER JOIN MemberLogin ml
ON tm.MemberLoginID = ml.MemberLoginID
INNER JOIN Member m
ON m.MemberID = ml.MemberID
WHERE tm.TeamID = @TeamID
END
AS
BEGIN
SELECT
tm.TeamID,
m.MemberID,
m.MemberName,
m.MemberStatus,
ml.MemberLoginName,
ml.MemberLoginID,
tm.MemberJoinedDate,
tm.MemberLeftDate
FROM TeamMember tm
INNER JOIN MemberLogin ml
ON tm.MemberLoginID = ml.MemberLoginID
INNER JOIN Member m
ON m.MemberID = ml.MemberID
WHERE tm.TeamID = @TeamID
END
so i want to add another table Team to this stored procedure to get the TeamStatus values=1
please give a help
Azeem AnzariPosted Aug 27, 2015, 7:00 AM
AS
BEGIN
SELECT
tm.TeamID,
m.MemberID,
m.MemberName,
m.MemberStatus,
ml.MemberLoginName,
ml.MemberLoginID,
tm.MemberJoinedDate,
tm.MemberLeftDate,
T.TeamStatus
FROM TeamMember tm
INNER JOIN MemberLogin ml
ON tm.MemberLoginID = ml.MemberLoginID
INNER JOIN Member m
WHERE tm.TeamID = @TeamID and T.TeamStatus=1
Please mark as accepted if its useful for you.