I am querying the t_Termination_Call_Detail with the following query but I am trying to place a date range search, and conditions on the DigitsDialed (='14334'), Variable1 (XFR_Tier1).
how do i modfiy this query so that I can have this daterange search and conditions on DigitsDialed and Variable1?
SELECT [PeripheralID]
,[DateTime]
,[DigitsDialed]
,[CallDisposition]
,[Duration]
,[RingTime]
,[Variable1]
,[DNIS]
,[ANI]
,[CallDispositionFlag]
FROM [cc123_hds].[dbo].[t_Termination_Call_Detail]