On Wed, Dec 14, 2011 at 3:04 AM, p51b.mustang wrote:
>
> On the left side of my brain, I say firebird would collect all records from
> the select first and then perform inserts with no problems.
> On the right side, I say as records are inserted these very same records my
> be gathered into the
Em 14/12/2011 06:25, Norman Dunbar escreveu:
> By the way, I've not tried this in Firebird 2.5 as I don't want to
> have to kill off my session to stop it running away!
Hi Norman
I've tried in Firebird 2.5.1 (just for curiosity) and the behavior is
still the same. :)
Regards,
Fabio Schunig
>In Oracle I frequently use "insert into table_a select * from table_a"
>to build up some volume in a table. The first time I tried that in
>Firebird, it never finished - I had to kill it.
Doesn't sound quite logical that Firebird should behave this way, but I don't
doubt your observations and
Morning David,
On 14/12/11 08:04, p51b.mustang wrote:
> Hi,
> I am seeking advice on whether this is possible:-
> ...
> In other words a table inserting into itself. Essentially for a particular
> sitecode the records are duplicated for each sitecode relationship.
>
> On the left side of my br
Hi,
I am seeking advice on whether this is possible:-
insert into table_X (mydatetime, taskcode, sitecode)
Select x.mydatetime, x.taskcode, ss.sitecode
From table_X x
inner join sites ss on (ss.siteparentcode=x.sitecode)
Where (x.mydatetime between '30 nov 2010' and '1 nov 2011
