After much searching I am coming up empty which leads me to believe the advanced things I was hoping for will not be happening. I do hope I am wrong.
What I wanted to do was have a IVR for our technicians in the field to call and have it return the work we they performing like so:
TTS from select query: "Job 123 replace coil". (SELECT 'Job '+CONVERT(varchar(200),JOBID)+' '+JOBDESCR)
Prompt
1. If this is completed press 1.
2. If this requires additional materials to complete press 2.
etc etc.
Determine the prompt and perform an appropriate update query against the job ticket being processed.
I could even live with "Enter job ticket now", accept the user input and than act upon it, but can the IVR repeat the input?
I am guessing it should be able to verify the user input(??)
I wanted to buy the VAD today so I could start playing with it but $1000 for something that may not work for me and no returns on it regardless of whether it will fulfill my requirements isn't going to happen.

