DELETE FROM [dbo].[eh_evidencija] WHERE (([id_student] = @Original_id_student) AND ([id_ispit] = @Original_id_ispit) AND ((@IsNull_ocjena = 1 AND [ocjena] IS NULL) OR ([ocjena] = @Original_ocjena))) INSERT INTO [dbo].[eh_evidencija] ([id_student], [id_ispit], [ocjena]) VALUES (@id_student, @id_ispit, @ocjena); SELECT id_student, id_ispit, ocjena FROM eh_evidencija WHERE (id_ispit = @id_ispit) AND (id_student = @id_student) SELECT id_student, id_ispit, ocjena FROM dbo.eh_evidencija UPDATE [dbo].[eh_evidencija] SET [id_student] = @id_student, [id_ispit] = @id_ispit, [ocjena] = @ocjena WHERE (([id_student] = @Original_id_student) AND ([id_ispit] = @Original_id_ispit) AND ((@IsNull_ocjena = 1 AND [ocjena] IS NULL) OR ([ocjena] = @Original_ocjena))); SELECT id_student, id_ispit, ocjena FROM eh_evidencija WHERE (id_ispit = @id_ispit) AND (id_student = @id_student) DELETE FROM [dbo].[eh_ispiti] WHERE (([id_ispit] = @Original_id_ispit) AND ((@IsNull_naziv = 1 AND [naziv] IS NULL) OR ([naziv] = @Original_naziv))) INSERT INTO [dbo].[eh_ispiti] ([id_ispit], [naziv]) VALUES (@id_ispit, @naziv); SELECT id_ispit, naziv FROM eh_ispiti WHERE (id_ispit = @id_ispit) SELECT id_ispit, naziv FROM dbo.eh_ispiti UPDATE [dbo].[eh_ispiti] SET [id_ispit] = @id_ispit, [naziv] = @naziv WHERE (([id_ispit] = @Original_id_ispit) AND ((@IsNull_naziv = 1 AND [naziv] IS NULL) OR ([naziv] = @Original_naziv))); SELECT id_ispit, naziv FROM eh_ispiti WHERE (id_ispit = @id_ispit) DELETE FROM [dbo].[eh_studenti] WHERE (([id_student] = @Original_id_student) AND ((@IsNull_ime_p = 1 AND [ime_p] IS NULL) OR ([ime_p] = @Original_ime_p))) INSERT INTO [dbo].[eh_studenti] ([id_student], [ime_p]) VALUES (@id_student, @ime_p); SELECT id_student, ime_p FROM eh_studenti WHERE (id_student = @id_student) SELECT id_student, ime_p FROM dbo.eh_studenti UPDATE [dbo].[eh_studenti] SET [id_student] = @id_student, [ime_p] = @ime_p WHERE (([id_student] = @Original_id_student) AND ((@IsNull_ime_p = 1 AND [ime_p] IS NULL) OR ([ime_p] = @Original_ime_p))); SELECT id_student, ime_p FROM eh_studenti WHERE (id_student = @id_student) select s.ime_p as 'Ime i prezime', count (e.id_ispit) as 'Broj polozenih ispita', avg (e.ocjena) as 'Prosjek ocjena' from eh_studenti s, eh_evidencija e where e.ocjena>1 and s.id_student=e.id_student group by s.ime_p