já jsem zkusil sesmolit toto

  CREATE TRIGGER deactive_company
	ON f_table
    AFTER UPDATE
    AS
		DECLARE @cnt int
		DECLARE @cntMax int
		SELECT @cnt=1;
		SELECT @cntMax =Count(ID) FROM f_table
		DECLARE @y int
		DECLARE @id decimal(10,0)
		DECLARE @deleted int
		
	WHILE @cnt <= @cntMax
	BEGIN --While Loop
		SELECT @id=ID,@deleted = DELETED FROM f_table WHERE RowNumber=@cnt
		IF @delted = 1
			BEGIN
				DELETE FROM ROOT WHERE ID = @id
				DELETE FROM MAIN_VIEW WHERE ID = @id
			END
		--do something based on the query

		SELECT @cnt = @cnt+1
	END --While Loop
	
	GO