ALTER TRIGGER NewTeamNumber 
ON  LeagueTeams
For INSERT
AS 
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	--SET NOCOUNT ON

	Declare @PrevTeamID as INT
	Declare @CurrTeamID as INT	

	Set @PrevTeamID = 0
	Set @CurrTeamID = 0 

	Declare LeagueTeams_cursor CURSOR SCROLL
	FOR SELECT TeamNumber from LeagueTeams WHERE Activity_ID = (SELECT Activity_ID FROM Inserted)
	Open LeagueTeams_Cursor
	Fetch First From LeagueTeams_Cursor
	INTO @CurrTeamID
	While @@Fetch_Status=0
	BEGIN

	End