ALTER PROCEDURE zad2
	@StudyName nvarchar(100),
	@Semester int
AS
BEGIN
	DECLARE @idStudy int;
	DECLARE @idOldEnrollment int;
	DECLARE @idNewEnrollment int;
	DECLARE @max int;

	IF EXISTS(select 1 from studies where name=@StudyName) --pytamy o studia
	BEGIN
		SET @idStudy=(select idStudy from  studies where name=@StudyName)
		IF EXISTS(select 1 from enrollment where semester=@semester and idStudy=@idStudy)
		BEGIN
			SET @idOldEnrollment=(select IdEnrollment from enrollment where semester=@semester and idStudy=@idStudy);
			print 'id enrollmet to ooo ' + CAST(@idOldEnrollment AS VARCHAR(100));
			IF EXISTS(select 1 from enrollment where IdStudy=@idStudy AND semester=(@Semester+1))
				SET @idNewEnrollment=(select IdEnrollment from enrollment where semester=(@Semester+1) and idStudy=@idStudy);
			ELSE
			BEGIN
				SET @max = (select MAX(IdEnrollment) from enrollment);
				SET @idNewEnrollment=@max+1;
				INSERT INTO enrollment(IdEnrollment, Semester, IdStudy, StartDate) VALUES (@idNewEnrollment, (@Semester+1), @idStudy, GETDATE());
				SET @idNewEnrollment=(select IdEnrollment from enrollment where semester=(@Semester+1) and idStudy=@idStudy);
			END
		END
		ELSE
			RAISERROR('brak podanego enrollmentu',10,1);
	END
	ELSE
		RAISERROR('brak podanych studiow',10,1);

	UPDATE student SET IdEnrollment=@idNewEnrollment where IdEnrollment=@idOldEnrollment;
END;
GO

przy enroll student -----------------------------------------------
ALTER PROCEDURE zad1
	@IndexNumber nvarchar(100),
	@FirstName nvarchar(100),
	@LastName nvarchar(100),
	@BirthDate date,
	@StudyName nvarchar(100),
	@Semester int
AS
BEGIN
	DECLARE @idStudy int;