Funkcja obliczająca srednią Opcje

[sandra1023]

Mam takie tabelki :

[SQL] pobierz, plaintext 
 CREATE TABLE [dbo].[Student](
	[ID_Studenta] [int] NOT NULL,
	[Student_imie] [varchar](50) NOT NULL,
	[Student_nazwisko] [varchar](50) NOT NULL,
	[Student_data_ur] [datetime] NOT NULL,
	[ID_kierunek] [int] NOT NULL,
	[Nr_albumu] [int] IDENTITY(1,1) NOT NULL,
	[Semestr] [int] NOT NULL,
	[Data_rozp_studiow] [datetime] NOT NULL,
	[PESEL] [int] NOT NULL,
	[Adres] [nvarchar](max) NOT NULL,
	[Email] [varchar](50) NULL,
	[Uwagi] [nvarchar](max) NULL,
 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 
(
[SQL] pobierz, plaintext 

i

[SQL] pobierz, plaintext 
CREATE TABLE [dbo].[Archiwum](
	[ID_Student] [int] NOT NULL,
	[Student_imie] [varchar](50) NOT NULL,
	[Student_nazwisko] [varchar](50) NOT NULL,
	[Data_rozp_studiow] [datetime] NOT NULL,
	[Data_ukonczenia_studiow] [datetime] NOT NULL,
	[Nr_albumu] [int] NOT NULL,
	[PESEL] [int] NOT NULL,
	[ID__Kierunek] [int] NOT NULL,
	[Uwagi] [nvarchar](max) NULL,
 CONSTRAINT [PK_Archiwum] PRIMARY KEY CLUSTERED
[SQL] pobierz, plaintext 

i chcę żeby po ukończeniu studiów student był przenoszony do archiwum. Kombinowałam z tym wiele ale niestety jestem poczatkujaca. Mysle że można to zrobic za pomocą trigera który dla semestru>5 przenosi studenta do archiwum ale nie wiem jak to zapisać. Bardzo proszę o pomoc.

[sandra1023]

zrobilam to tak:

[SQL] pobierz, plaintext 
ALTER TRIGGER [dbo].[archiwu]
ON [dbo].[Student]
after INSERT,UPDATE 
AS 
IF ((SELECT semestr FROM Student)>5)
begin
UPDATE dbo.Student
SET archiwum=1
end
[SQL] pobierz, plaintext 

tylko ze po zrobieniu

[SQL] pobierz, plaintext 
UPDATE dbo.Student
SET Semestr=7
WHERE Student_imie ='jan'
[SQL] pobierz, plaintext 

mam taki blad

[SQL] pobierz, plaintext 
Msg 512, Level 16, State 1, Procedure archiwu, Line 5
Subquery returned more than 1 value. This IS NOT permitted when the subquery follows =, !=, <, <= , >, >= OR when the subquery IS used AS an expression.
The statement has been terminated.
[SQL] pobierz, plaintext 

Jak to naprawic?