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

Program to produce the given output , Given a file named maze1.txt whose co... Given a file named maze1.txt whose contents is 1 0 2 2 1 2 3 0 3 2 2 1 2 0 2 2 3 0 1 1 3 1 0 0 2 0 3 0 0 1 2 0 3 2 2 0 1 2 3 2 1 0 0 1 1 0 0 0 your program when run as a.out

Simulation algorithm, Please remember to read and follow all of the assignm... Please remember to read and follow all of the assignment guidelines. This assignment will expand upon the simulation algorithm given in class to produce a program which may be u

Shell script for to change & display system prompt and path, Normal 0 ... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Python, Write a python script that will take two file names as input (src, ... Write a python script that will take two file names as input (src, dest). Open src reading each line in the file, and replacing any occurrences of name with the string "redacted".

Assignment about prolog, Hi I have an assignment for prolog languagle is ... Hi I have an assignment for prolog languagle is it possible to get help

Assembly language coding, i need a coding to glow 8 LEDs on a port with pwm... i need a coding to glow 8 LEDs on a port with pwm effect

Outline the norms to be designing a web page, Question: (a) Outline th... Question: (a) Outline the six norms to be considered before designing a Web page. (b) Write a program such that when a user right-clicks anywhere on a Web page, the follow

Java, wat is- m=5; n=3; x=m++-n+++m; wat is- m=5; n=3; x=m++-n+++m;

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

Solve the given initial value problem, Solve the following initial value pr... Solve the following initial value problem y (3) - 5y'' - 22y' + 56 y= 0;       y(0) = 1;           y'(0) = -2;         y''(0) = -4 Solution : r 3 - 5r 2 - 22r + 56 = (