Posted by Erland Sommarskog on 05/03/07 14:19

eighthman11 (rdshultz@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: INSERT - one record at a time
• Prev in forum: Re: INSERT - one record at a time
• Thread view: Re: INSERT - one record at a time

[Reply to this message]