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

Compare 2 strings, Normal 0 false false false EN-US X... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

No Linux Audible, Why no Audible support for Linux? Maybe they should use a... Why no Audible support for Linux? Maybe they should use a browser interface?

Cookies management with perl, One of the main strengths of the Perl program... One of the main strengths of the Perl programming language are its powerful text manipulation features. In this assignment, you will put them to use for writing a Perl program tha

Animals, Let us say we have a list of 10 animal objects called "animals" in... Let us say we have a list of 10 animal objects called "animals" in Alice. Write the code to move them forward synchronously by 1 meter.

What is hiding a method? explain, Question 1 Explain the three traits of O... Question 1 Explain the three traits of Object Oriented Programming Question 2 Write a note on (a) Assignment Operators                             b) Bitwise Operators.

Shell script to compare that given two files are same or not, Normal 0 ... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Php programming help, How to read file in PHP. How to read file in PHP.

Program to create multithreaded calculator, Multithreaded Calculator I... Multithreaded Calculator In this Lab, you will be implementing a simple multithreaded calculator. Our calculator will accept expressions as infix notation text strings consist

Explain what the return value of fork-shell programming, Simple Shell ... Simple Shell In this LAB, you will explore and extend a simple Unix shell interpreter. In doing so, you will learn the basics of system calls for creating and managing process

Prelude to Programming, How does a Case Structure differ from a Case struct... How does a Case Structure differ from a Case structure program in pseudocode