> SELECT @id=x.ID FROM xxx x inner join inserted i on i.id = x.id Inner join
> deleted d on i.id = d.id

>
> However, it's difficult to conceive of many situations where updates like
> this between normalized columns in a table would make sense. Maybe what
you
> really need is a redesign. Of course I could be completely wrong since I
> don't know your data but your requirement does look a little odd - maybe
you
> could explain just what is represented by X1,X2,X3.
>
> --
> David Portas
> SQL Server MVP
> --
>
>

> > ALTER DATABASE database_name
> > SET RECURSIVE_TRIGGERS ON
> > GO
> >

"Michael Schwab" <michael.sc_nospam@gmx.net> wrote in message
news:41535325$0$22759$db0fefd9@news.zen.co.uk...
> ...but too difficult for me (obviously).
> Take the following test trigger:
>
> Create Trigger "xxx_Trigger1"
> On dbo.xxx
> For update
> As
> declare @id int
>
> SELECT @id=x.ID FROM xxx x inner join inserted i on i.id = x.id Inner join
> deleted d on i.id = d.id
>
> if update(x2)
> begin
> UPDATE xxx set X3=x2 WHERE ID=@id
> end
>
> --why is the trigger not reaching this? (it only responds to an update on
> x2)
> if update(x1)
> BEGIN
> UPDATE xxx set X2=x1 WHERE ID=@id
> END
>
>
> The idea is the following: when x1 is updated it should update x2 which
> should update x3. When x2 is updated only x3 should be updated. What's
wrong
> with my brains?
>
> Thanks,
>
> Michael
>
>

"Jonathan Chong" <jonathan@3exp.com> wrote in message
news:Ob1Y7reoEHA.324@TK2MSFTNGP11.phx.gbl...
> Well, David Portas gave a good practice in trigger scripting.
> Your problem might due to the server configuration. Take a look in BOL
about
> "Using Nested Triggers" and "RECURSIVE_TRIGGERS". May be you need to turn
> recursive triggers on as:
>
> ALTER DATABASE database_name
> SET RECURSIVE_TRIGGERS ON
> GO
>
>
> "Michael Schwab" <michael.sc_nospam@gmx.net> wrote in message
> news:41535325$0$22759$db0fefd9@news.zen.co.uk...
> > ...but too difficult for me (obviously).
> > Take the following test trigger:
> >
> > Create Trigger "xxx_Trigger1"
> > On dbo.xxx
> > For update
> > As
> > declare @id int
> >
> > SELECT @id=x.ID FROM xxx x inner join inserted i on i.id = x.id Inner
join
> > deleted d on i.id = d.id
> >
> > if update(x2)
> > begin
> > UPDATE xxx set X3=x2 WHERE ID=@id
> > end
> >
> > --why is the trigger not reaching this? (it only responds to an update
on
> > x2)
> > if update(x1)
> > BEGIN
> > UPDATE xxx set X2=x1 WHERE ID=@id
> > END
> >
> >
> > The idea is the following: when x1 is updated it should update x2 which
> > should update x3. When x2 is updated only x3 should be updated. What's
> wrong
> > with my brains?
> >
> > Thanks,
> >
> > Michael
> >
> >
>
>