We have a sql server that store cdr for our pbx and another server that store the data for the results of a survey that we office to clients after the call.
We have a sql query that match the call with the results of the survey of the calls. In the CDR side it reads from a view while from a table for the survey results.
This query works ok for results of the previous month, but for larger date ranges it takes too much time. We would like to have it optimized with a way to select the range of dates to include in the query.
Category: IT & Programming
Project size: Medium
Is this a project or a position?: A project
Required availability: Part time