|Subject||Re: [firebird-support] Re: Query help: getting non used records in a table|
> you don't need an auxilary table to do this.Not always. When doing JOINs for example, this won't be
> You can write a small SP to do suspend used (or unused) numbers via
> cursor(plus counter) loop. This will be more economic.
a join with an indexed table, but with a resultset (from the
procedure) that's being generated "on the fly". This could get
> You know,With regards,
> To be a Firebirder means of to be speedy-homoeconomicus-gonzales.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!