Hi all,
Sorry but this is not a pfc question.
I am optimzing a stored procedure and i want to know which of the syntax is
better and faster,
1. Using the
Insert <temptable>
select .... from <temptable>
Or
2. getting fist all the columns in the temptables then insert it using the
INSERT INTO <TEMPTABLES> VALUES <.....>
This is inside the loop
Any help will be highly appreciated,
-Rick-
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
