Posted by Alexander Kuznetsov on 03/09/06 19:03

Ryan,

another possible workaround might be to :

bulk insert into a staging table

BEGIN TRANSACTION
DELETE * FROM Whatever
INSERT INTO Whatever... select ... from staging table
COMMIT TRANSACTION

• Next in forum: Help optmizing a stored proc
• Prev in forum: Re: Can't fit results of tsql query in excel
• Thread view: Re: Execution Plan Hinting

[Reply to this message]