Daniel
Your second SQL statement will produce a Cartesian table
Insert into fun_informations
(Select conn.INT_InternalCallId as INT_InternalCallId,
'CID' as CHR_PropName,
'AAAAAA' as CHR_PropValue,
1 as INT_Updated,
null as INT_Key
from cti_connections conn left join app_ivrtable ivr
on conn.chr_device=ivr.chr_device
where conn.int_state = 7 and
ivr.CHR_Machine = 'm1'
and ivr.INT_IVRLine = '1'),
>>
(Select conn.INT_InternalCallId as INT_InternalCallId,
'CPN' as CHR_PropName,
'BBBBB' as CHR_PropValue,
1 as INT_Updated,
null as INT_Key
from cti_connections conn left join app_ivrtable ivr
on conn.chr_device=ivr.chr_device
where conn.int_state = 7 and
ivr.CHR_Machine = 'm1'
and ivr.INT_IVRLine = '1')
>> You need a UNION statement?
Hernando
*********************************************************************
This message and any attachments are solely for the intended recipient. If you are not the
intended recipient, disclosure, copying, use or distribution of the information included
in this message is prohibited -- Please immediately and permanently delete.
