gistfile1.sql

create trigger m10sav2_Rent_logger_insert on m10sav2_Rent after insert
as
begin
	declare @name varchar(50)
	declare @item varchar(50)
	declare @start smalldatetime
	declare @end smalldatetime
	
	select 
		@name = first_name + ' ' + last_name
		, @item = name
		, @start = start_time
		, @end = end_time
	from inserted
		join m10sav2_Person on m10sav2_Person.person_id = inserted.person_id
		join m10sav2_Sportstaff on m10sav2_Person.item_id = inserted.item_id
	
	insert into m10sav2_log
		
end