Converting data to wav format

Question

Post reply

Converting data to wav format

hayamal

Newbie

Points: 8
More actions
May 27, 2011 at 5:36 pm

#99675

Hello
I have an application. It deals with the following columns.
customer Name varchar(100)
customer Phone varchar(20)
Department varchar(50)
Here it how it works:
The customer service takes input from the customer and enters the Name, Customer's Phone# and the department they would like to talk to.
(Note: The Sales Person EMail ID, Cell#, Phone#, Pager# are stored with the department. The moment, the customer service takes input, an email, pager will be sent to the Sales Person and it's working fine.)
Now, the Sales Persons wanted that they should be notified in their regular phone, BlackBerry by voice mail as soon as their department has been selected.
The application has been designed using C#, SQL Server 2005.
My questions:
(1) How do I convert the SQL data in a wave format?
(2) Do I need an interface to dial the phones and convey the voice msg?
(3) Are there any freewares available so that I can use it?
Appreciate your help.
Thanks again,
OppiliVenkat

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

Pretty sure this article will provide you with some useful information.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

hayamal Newbie Points: 8 More actions · Answer 2

thanks so much for your response. Let me read this and get back to you.

Regards

OV

Lowell SSC Guru Points: 323547 More actions · Answer 3

Sean Lange (5/31/2011)
Pretty sure this article will provide you with some useful information.

nice link!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Sean Lange SSC Guru Points: 286609 More actions · Answer 4

Lowell (6/1/2011)
Sean Lange (5/31/2011)
Pretty sure this article will provide you with some useful information.
nice link!

😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/