I need an application that will gather data from one SQL Database and update another.
Data is contained in dbo.CallList with following fields: Customer_ID, AlreadyPickedUp, Phone_Number.
dbo.CallResults contains the following fields: Customer_ID, NumberOfCalls, Call_Successful.

I need a function that will gather data from dbo.CallList. Filters to see if AlreadyPickedUp is = 1, if so, update dbo.CallResults as Successful (matching the Customer_ID)

ElseIf AlreadyPickedUp is 0, then While dbo.CallList is not EOF, make a call (I will get this function done) and update dbo.CallResults with the appropriate amount of attempts. Should go through all of the items in the dbo.CallList table before making the second attempt. If the previous phone call attempt was to the same phone number then skip.

Let me know if you have any questions.

Posted Date: 2/10/2012 6:27:22 PM | Location : United States

Ask an Expert

Related Discussions:- Sql vb integration, computer programming, Assignment Help, Ask Question on Sql vb integration, computer programming, Get Answer, Expert's Help, Sql vb integration, computer programming Discussions

Write discussion on Sql vb integration, computer programming
Your posts are moderated

Write your message here..

Related Questions

Find the cookies expiring, Your program can be invoked with option: -d date... Your program can be invoked with option: -d date, where date is entered in dd/mm/yyyy format. In this case, it must only print the following string: Found cookies expiring bef

MATLAB, Who can help with MATLAB? Who can help with MATLAB?

Shell script to print left traingle, Normal 0 false false f... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Implement a lunar lander simulation, 1. Modify your solution to #8 so that ... 1. Modify your solution to #8 so that if an ellipse is touched by the mouse, it turns permanently green.Bonus (up to +5): a green ellipse stops moving, but recovers after 5 seconds

Language-integrated query, Language-Integrated Query Language integrated qu... Language-Integrated Query Language integrated query (LINQ, obvious "link") is a Enthusiasm .NET Structure element that contributes ancient data querying abilities to .NET dialects,

Perform dbscan clustering and k means, Perform Dbscan Clustering and K mean... Perform Dbscan Clustering and K means I have a simple array of data. I need to perform dbscan clustering and k means based on the values in the array.detailed description  bel

Display & list directory contents, Normal 0 false false fal... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Database, How to create an ER diagram? How to create an ER diagram?

Program to calculate the triangle area, Write a program that will allow the... Write a program that will allow the user to input the corners of a triangle. The program will draw small yellow circles for each input point, then draw the triangle and calculate t

Computer design project , I''m studying electrical engineering, and this se... I''m studying electrical engineering, and this semester im taking course that called Computer Design. in this course they need me to a final project about any thing we took during