ALTER PROCEDURE [dbo].[LeagueTableProcedure] 
	@league int=null,
	@nation int=null ,
	@season int=null Output,
	@round int=null

AS
begin

if @league=null
SELECT     @league=Competitions.CompetitionId, @season=Seasons.Seasonid, @round=Rounds.RoundId
FROM         Competitions INNER JOIN
                      Seasons ON Competitions.CompetitionId = Seasons.CompetitionId INNER JOIN
                      Rounds ON Seasons.Seasonid = Rounds.SeasonId
WHERE     (Competitions.AreaId = @nation) AND (Seasons.EndDate > getdate())
end if

IF (@season=null)
SELECT     @season=Seasons.Seasonid, @round=Rounds.RoundId
FROM         Competitions INNER JOIN
                      Seasons ON Competitions.CompetitionId = Seasons.CompetitionId INNER JOIN
                      Rounds ON Seasons.Seasonid = Rounds.SeasonId
WHERE     (Competitions.AreaId = @nation) AND (Seasons.EndDate > GETDATE()) AND (Competitions.CompetitionId = @league) AND 
                      (Rounds.RoundEnd > GETDATE())
end if

if @round=null then begin
SELECT     @round=Rounds.RoundId
FROM         Seasons INNER JOIN
                      Rounds ON Seasons.Seasonid = Rounds.SeasonId
WHERE     (Rounds.RoundEnd > GETDATE())
end
end if



end


SELECT     t.Team_name, t.TeamID, lt.rank, lt.MatchWon, lt.MatchDraw, lt.MatchLost, lt.points, lt.GoalsScored, lt.GoalsRecieved, la.rank AS awayRank, 
                      la.MatchWon AS awayWon, la.MatchDraw AS awayDraw, la.MatchLost AS awayLost, la.points AS awayPoints, la.GoalsScored AS awayScored, 
                      la.GoalsRecieved AS awayRecieved, lh.rank AS homeRank, lh.MatchWon AS homeWon, lh.MatchDraw AS homeDraw, lh.MatchLost AS homeLost, 
                      lh.points AS homePoints, lh.GoalsScored AS homeScored, lh.GoalsRecieved AS homeRecieved,
                          (SELECT     COUNT(TeamTableInfo.TeamID) AS Expr1
                            FROM          Seasons INNER JOIN
                                                   Competitions ON Seasons.CompetitionId = Competitions.CompetitionId INNER JOIN
                                                   Rounds ON Seasons.Seasonid = Rounds.SeasonId INNER JOIN
                                                   TeamTableInfo INNER JOIN
                                                   LeagueTableTotal ON TeamTableInfo.TeamID = LeagueTableTotal.TeamId ON Rounds.RoundId = LeagueTableTotal.RoundId
                            WHERE      (Seasons.CompetitionId = @league) AND (t.TeamID = TeamTableInfo.TeamID)
                            GROUP BY TeamTableInfo.TeamID) AS gamePlayed, t.TeamID AS Expr1
FROM         Seasons AS s INNER JOIN
                      Competitions AS c ON s.CompetitionId = c.CompetitionId INNER JOIN
                      Rounds AS r ON s.Seasonid = r.SeasonId INNER JOIN
                      TeamTableInfo AS t INNER JOIN
                      LeagueTableTotal AS lt ON t.TeamID = lt.TeamId ON r.RoundId = lt.RoundId INNER JOIN
                      LeagueTableAway AS la ON r.RoundId = la.RoundId INNER JOIN
                      LeagueTableHome AS lh ON r.RoundId = lh.RoundId
WHERE     (r.RoundId = @round)

quote:

---

IF...ELSE
Imposes conditions on the execution of a Transact-SQL statement. The Transact-SQL statement following an IF keyword and its condition is executed if the condition is satisfied (when the Boolean expression returns TRUE). The optional ELSE keyword introduces an alternate Transact-SQL statement that is executed when the IF condition is not satisfied (when the Boolean expression returns FALSE).

Syntax
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]

---

IF @league=null
BEGIN
    SELECT     @league=Competitions.CompetitionId, @season=Seasons.Seasonid, @round=Rounds.RoundId
    FROM         Competitions INNER JOIN
                          Seasons ON Competitions.CompetitionId = Seasons.CompetitionId INNER JOIN
                          Rounds ON Seasons.Seasonid = Rounds.SeasonId
    WHERE     (Competitions.AreaId = @nation) AND (Seasons.EndDate > getdate())
END

quote:

---

Originally posted by madhivanan

Also
If @league=null

should be

If @league is null

Madhivanan

Failing to plan is Planning to fail

---