Posted by eighthman11 on 05/03/07 16:12

On May 3, 9:19 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> eighthman11 (rdshu...@nooter.com) writes:
> > I would like to thank everyone for their response. I tried both
> > examples I was given and both worked great. Right now I am in testing
> > and I am only using a handful of records. Later on when I am
> > inserting hundreds or thousands of records I will try both ways again
> > to see which processes faster. Once again I really appreciate the
> > help.
>
> Hundreds of thousands? I'm afraid that you will find both methods painfully
> slow. With that size I would be prepared to look into do modify the trigger,
> despite that it would void any warranties.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Sorry for the confustion. It isn't hundreds of thousands. It would
be hundreds OR thousands of records. In actuality I can't imagine
there ever being more than 3 thousand records.

[Back to original message]