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