How I can Insert 2 records with a Insert Select?
The SQl Clause that I am using is this:
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')
but I wanted to insert given of this clause
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')
It is possible? If not how i can do this?
Tks,
Daniel
