> For the 'production' stuff, I tend to stuff almost every
> task in the server as views, triggers, procedures, but
> sometimes you have that one task to do only once and want
> to use a quick and dirty obvious way :)

I agree. And I would have thought that the plan generated by IB6
would have been better in the situation you described.

What I would like is support for a temporary stored procedure for such
"quick and dirty" processing. Something like...

EXECUTE PROCEDURE
AS
DECLARE VARIABLE ...
BEGIN
my processing
END


Geoff Worboys
Telesis Computing