Invalid object name 'Beach_Group_Names'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Set @Group_Name = (SELECT TOP (1) Group_Name FROM Beach_Group_Names ORDER BY NEWID())

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Pepin z Hane
-- Create date: 
-- Description:	
-- =============================================
CREATE PROCEDURE Draw_Groups 
	-- Add the parameters for the stored procedure here
	@Tour_ID int
AS
	Declare Team_IDs Cursor for Select Team_ID from Registration where Tournament_ID = @Tour_ID and Group_Name = 'RP' order by Datum_Registrace
	Declare Beach_Group_Names Cursor for Select Group_Name from Beach_Group where Tournament_ID = @Tour_ID and Group_Name not like 'R%'
	Declare @Group_Counter int
	Set @Group_Counter = (select count (Group_Name) from Beach_Group where Tournament_ID = @Tour_ID)-4
	Declare @Team_ID int
	Declare @Celkovy_Pocet_Tymu int 
	Set @Celkovy_Pocet_Tymu = (select count(*) from Registration where Tournament_ID = @Tour_ID and Group_Name = 'RP')
	Declare @Pocet_Tymu_Ve_Skupine int
	Declare @Group_Name Varchar (5)
	Declare @Datum_Registrace Datetime
BEGIN
	Begin try
		begin transaction
			open Team_IDs
			Fetch NEXT from Team_IDs into @Team_ID 
			While @@Fetch_Status = 0 
			begin
				Set @Group_Name = (SELECT TOP (1) Group_Name FROM Beach_Group_Names ORDER BY NEWID())
				--
				while @Pocet_Tymu_Ve_Skupine >= @Celkovy_Pocet_Tymu/@Group_Counter begin
					if @Group_Name = 'A' begin
						Set @Group_Name = 'B'
					end
					else if @Group_Name = 'B' begin
					
						if @Group_Counter > 2 begin
							Set @Group_Name = 'C'
						end
						else begin
							Set @Group_Name = 'A'
						end
					end
					else if @Group_Name = 'C' begin
					
						if @Group_Counter > 3 begin
							Set @Group_Name = 'D'
						end
						else begin
							Set @Group_Name = 'A'
						end
					end
					else if @Group_Name = 'D' begin
					
						if @Group_Counter > 4 begin
							Set @Group_Name = 'E'
						end
						else begin
							Set @Group_Name = 'A'
						end
					end
					else if @Group_Name = 'E' begin
					
						if @Group_Counter > 5 begin
							Set @Group_Name = 'F'
						end
						else begin
							Set @Group_Name = 'A'
						end
					end
					else if @Group_Name = 'F' begin
						Set @Group_Name = 'A'
					end
				end
				--
				Set @Datum_Registrace = (select Datum_Registrace from Registration where Tournament_ID = @Tour_ID and Team_ID = @Team_ID)	
				Insert into Registration values (@Tour_ID, @Group_Name, @Team_ID, 1, @Datum_Registrace, 0,0,0,0,0,0,0,0)
			end
		commit transaction
		return 1
	End Try
	begin Catch
		rollback
		return 0
	end Catch
END
GO