Which of these two variants is going to be the more efficient in running?

 DECLARE Zapper SENSITIVE CURSOR FOR ZapperSQL;
 DECLARE txt VARCHAR;

 SET txt = ''SELECT * FROM emReadStatus WHERE emReadStatus._fkEMails = ''+CAST(OLDROW._MsgNo AS VARCHAR);

 PREPARE ZapperSQL FROM txt;
 OPEN Zapper;
 WHILE NOT EOF(Zapper) DO DELETE FROM Zapper;
 END WHILE;


or


EXECUTE IMMEDIATE 'DELETE FROM emReadStatus WHERE emReadStatus._fkEMails = '+CAST(OLDROW._MsgNo AS VARCHAR);



Roy Lambert

Roy,

<< Which of these two variants is going to be the more efficient in running?
>>

The second - it has less call overhead.

--
Tim Young
Elevate Software
www.elevatesoft.com