Esta consulta ayuda a encontrar los registros de inicio (S) y finalización (E), basados en el remoteId de en tabla “tblCdrFields”

declare @trunk as varchar(8)
declare @remoteid as int
declare @remoteIdRegS as int
set @remoteIdRegS=44653
set @trunk= (select top 1 Cdrfields_sTrunkGroup from tblcdrfields WHERE Cdrfields_lRemoteId=@remoteIdRegS)
set @remoteid= (select top 1 Cdrfields_lRemoteId from tblcdrfields WHERE Cdrfields_lRemoteId=@remoteIdRegS)
select cdrpbx_sRegister,cdrpbx_lRemoteId from tblcdrpbx where CdrPbx_lRemoteId=@remoteIdRegS union
select top 1 cdrpbx_sRegister,cdrpbx_lRemoteId from tblcdrpbx where
CdrPbx_lRemoteId>@remoteid and substring(cdrpbx_sRegister,1,1)='E ' and
(substring(cdrpbx_sRegister,19,6)=@trunk or substring(cdrpbx_sRegister,11,6)=@trunk)
order by CdrPbx_lRemoteId asc

S 031 00 T000101 45787   116.0.13.14 07/06 17:43 00:20:40 C 5557879595    37988
E 114 00 T000101 T073056             07/06 18:20 00:16:18 C 5557879595    39181