Posted by Yas on 08/21/07 08:29

On 17 Aug, 09: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. Just out of curiosity how would you modify the above to use
NOT EXISTS ?

cheers
Yas

• Next in forum: MS SQL dealing with duplicate columns in rows?
• Prev in forum: Re: Dinamyc Function
• Thread view: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2

[Reply to this message]