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

Write a perl program to design a computer game, Write a Perl program ghici.... Write a Perl program ghici.pl, one of the simplest computer games. The program should generate a random integer between 1 and 1000 and asks the user to guess it. If the user ?nds t

Write a shell script to calculate gross salary, Write a shell script  (W.A... Write a shell script  (W.A.S.S) to calculate gross salary. Program # Write a shell script  (W.A.S.S) to calculate gross salary. echo "Enter any Basic Salary"     #echo is

Programming (problem solving), develop a pseudocode algorithm to determine ... develop a pseudocode algorithm to determine the total amount of extra cost changed to the organizers for expenses accurednduring the workshop. the code is to be written for an unde

Write an application to assign seats for each flight, ( Airline Reservation... ( Airline Reservations System ) A small airline has just purchased a computer for its new automated reservations system. You have been asked to develop the new system. You are to w

Ado. net, ADO. NET ADO.NET (ActiveX Information Things for .NET) is a set o... ADO. NET ADO.NET (ActiveX Information Things for .NET) is a set of programs elements that developers can use to accessibility data and data solutions. It is an element of the platf

Computer in education.., EXPLAIN CAI? AND ITS PITFALLS EXPLAIN CAI? AND ITS PITFALLS

Information management system, Write a detailed description on how you woul... Write a detailed description on how you would go about planning information system for an organisation

Define the procedures cons, Show that we can represent pairs of nonnegative... Show that we can represent pairs of nonnegative integers using only numbers and arithmetic operations if we represent the pair a and b as the integer that is the product 2 a 3 b .

What do you meant by a function, (a) (i) What do you meant  by a function? ... (a) (i) What do you meant  by a function? Are functions required when writing a C program? (ii) State one of the advantages to the use of functions. (iii) What do you meant by a

Software application, Does anyone know anything about java programming here... Does anyone know anything about java programming here?