All pastes #804637 Raw Edit

Something

public text v1 · immutable
·published 2007-12-03 17:01 UTC
rendered paste body
select *,TOLLFREENUMBERS.ALIASENGLISH as TFNAE, 
TERMINATINGNUMBERS.ALIASENGLISH as TFTAE 
FROM CPMTABLE,TOLLFREENUMBERS, TERMINATINGNUMBERS 
where ( CPMTABLE.TOLLFREENUMBER='800xxxxxxx' ) 
and CPMTABLE.TOLLFREENUMBER = TOLLFREENUMBERS.TOLLFREENUMBER 
and CPMTABLE.TERMINATINGNUMBER = TERMINATINGNUMBERS.TERMINATINGNUMBER 
and CALLDATETIME >= dbo.DayTime(GETUTCDATE(),11,10,45, 0)