Viewing 5 posts - 1 through 5 (of 5 total)
Both give the same result...! And QUOTED_IDENTIFIER is in both cases SET.
Could it be the case that SQL Server uses an index that is set on an...
November 15, 2004 at 1:09 am
Nope...!
We first ran the sp_ExecuteSQL: approx. 8 minutes
Then the QA: approx. 1 minute
Then the sp_ExecuteSQL again: approx. 8 minutes..........
November 9, 2004 at 2:37 am
Thanks for the help, so far!
declare @SQLString nvarchar(4000)
set @SQLSTring = 'insert into aggr_Sales
(Price, NetPrice, SalesID, DealerID, DealerName, Month, ProductGroup, NetProfit, GrossProfit, Quantity, Quarter, Year)
select
Price, NetPrice, SalesID, DealerID,...
November 9, 2004 at 12:12 am
The sp_ExecuteSQL is core of our 'load-engine' which is perfectly generic this manner for our batch-processing(and won't be changed in the near future, because of impact)!
The insert statements...
November 8, 2004 at 7:30 am
Viewing 5 posts - 1 through 5 (of 5 total)