Posted by Yas on 08/18/07 02:47

On 17 Aug, 08:11, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Yas(yas...@gmail.com) writes:
> > DOH!!! what a silly mistake. :-)
>
> It's often that when you work with something you are not really confident
> that you look for the difficult mistakes and overlook the simple typos.
>
> > do you think apart from that its fine
> > for inserting new rows into Table2 from Table1 trigger?
>
> Looks good to me. I would have used NOT EXISTS rather than the LEFT JOIN,
> as I think that expresses more clearly what is going on. But that's a matter
> of taste.
>

Thanks for all your advise and help! by the way do you if there is a
way to edit/change a Trigger once it has been created in MS SQL?

Yas

[Back to original message]