Hi.I have this problem in FB 2.5
with x as (SELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_1 WHERE
cond_w1UNIONSELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_2 WHERE cond_w2)
select tbl_2.pk_id from tbl_2 where tbl_2.pk_id in (select list(x.tbl2_pk_id)
from x
The plan in the X table is OK,
Then the new SP remains:
create or alter procedure VER_EDAD (
N_EDAD numeric(15,4),
SEPARADOR varchar(1),
CORTO char(1))
returns (
C_EDAD varchar(8))
as
begin
/* Procedure Text */
if (separador is null) then
separador = ' ';
if (corto is null) then
corto = 'N';
Hi.in the netx SP send the follow parameters5,' ','N' --->>>5 Años (perfect)
5,'','N' --->>>5 Años ( not 5Años) without space of separation
create or alter procedure VER_EDAD (
N_EDAD numeric(15,4),
SEPARADOR char(1),
CORTO char(1))
returns (
C_EDAD varchar()
as
begin
/*
Hello everyoneI'm having a problem, and I do not understand why.I have a
structure similar to:
with recursive
aux as (
select 0 as n
from rdb$database union all select aux.n + 1
from aux
where aux.n <= 20
)
select aux.n, mytable.id
from aux
LEFT JOIN mytable on aux.n
The idea is the following.
Have products and services that pass through different states (order,
committed, reviewed, approved, slope, bill, invoice), these may belong to a
period or many (period = months).
The filter may include the client query or not.
La idea es la siguiente.
Tengo productos
hoogroups.com> escribió:
Germán, as you can read Spanish, this article can be useful:
https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/
Greetings.
Walter.
On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com
[firebird-
Excellent, very simple. Thank Karol
El Martes, 6 de octubre, 2015 16:32:08, "liviusliv...@poczta.onet.pl
[firebird-support]" escribió:
Hi, ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END
regards,Karol Bieniaszewski From:
Hello everyone
There is the possibility of ordering the result of a SELECT in an order
specified by the user.For examplehaving a field NAMEin the clause ORDER BY
'PAUL, JOHN, PETER, MARIA'
Of course, that should be all the options set
Thank you.
Hola a todos
Existe la posibilidad de ordenar el
Para una mucho mejor traducción usa el traductor de Microsoft
http://www.bing.com/translator/
| |
| | | | | | | |
| TraductorDescargar aplicaciones Translator Translator Apps Skype Translator |
| |
| Ver en www.bing.com | Vista previa por Yahoo |
| |
| |
El
Hi.
in firebird 2.5
Simple descriptables
table_ud
ud_id integernotnullprimarykey
field_udvarchar(6)
rowcount: 383322
table_tmp
ud_id integer
cndinteger
index (cnd)
rowcount: 617
UPDATEtable_udud
SETud.field_ud = '201401'
WHEREud.ud_id in (SELECT t.ud_id FROMtable_tmp t where t.cnd =
look for CHR(13)+CHR(10) at the end of lines
open external table with editor (I use textpad) is good for big data.
good luck
Germán
El Jueves, 11 de septiembre, 2014 20:14:24, 'Edward Mendez'
emendez...@nc.rr.com [firebird-support] firebird-support@yahoogroups.com
escribió:
Hi All,
Run stadistic for database
- Look for index in de big tables. Look for Depth 2. In this case up Page
size one step, and run database statistical.
- Look memory at each step
Good luck
Germán
El Viernes, 12 de septiembre, 2014 15:37:38, Alexey Kovyazin a...@ib-aid.com
[firebird-support]
in fb 1.5 fix and backup database
in fb 2.5 restore database with fix malformed unicode_fss data and metadata
atencion to date and datetime data en fb 1.5
good luck
El Miércoles, 29 de octubre, 2014 11:13:01, 'm...@lawinegevaar.nl'
m...@lawinegevaar.nl [firebird-support]
Yes. in fb 1.5 is very disastrous
Thank
El Miércoles, 29 de octubre, 2014 10:39:34, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com escribió:
Hi.
in firebird 2.5
Simple descrip tables
table_ud
ud_id integer not null
Costantino
Mi recomendacion para realizar insert de gran cantidad de datos, es utilizar
tablas externas. Estas son extremadamente rapidas.Para esto
1 tenes que definir un archivo de texto con los datos. 2 crear la tabla externa
en firebird
3 realizar el insert a la tabla definitiba de los
15 matches
Mail list logo