Comments by Member 12348965 (Top 2 by date)

Member 12348965 4-Mar-16 19:15pm View

If he used Distinct then that means that the values returned in the select statement already contain duplicates, he just needs to look at the results of his select query and then follow your direction

Member 12348965 4-Mar-16 19:11pm View

Hi, I don't understand how this trigger is supposed to do any validation of time, but the following query will create a trigger that does what your trigger is trying to do, I hope it helps
CREATE TRIGGER trigger_UpdateGettemp ON Team
FOR UPDATE AS
BEGIN
DECLARE @name VARCHAR(250)
DECLARE @TL VARCHAR(100)
DECLARE @Team_assignment VARCHAR(50)
DECLARE @ID int

set @ID=(Select ID from Inserted)
set @Team_assignment=(Select Team_Assignment from Inserted)
SELECT @name = Team.Full_name ,
@TL = Team.TL
FROM Team join SkillsGet on SkillsGet.TL = Team.TL where Team.ID=@ID

UPDATE Gettemp set Full_name = @name where Team_Assignment= @Team_assignment
END

update Team set [Time]=250 where ID=@ID;

update Gettemp set Full_name = (
(select Full_name from Team where ID=@ID and Team_Assignment= @Team_assignment )

) where ID=@ID