Sql vb integration, computer programming, Programming Languages

Sql vb integration, computer programming, Programming Languages

Assignment Help:

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.

Related Discussions:- Sql vb integration, computer programming

Python, interference of waves

interference of waves

Matlab, ,how to write matlab program for fast decoupled method

,how to write matlab program for fast decoupled method

Html code to create a web page design , 1. Develop HTML code to create a W...

1. Develop HTML code to create a Web page with the red background and title "My First Page" in any other color. 2. Develop an HTML document with details of your name, telephon

Data analytics, can i get assignments on Data analytics?

can i get assignments on Data analytics?

How pointer works? what are the uses of pointers, how pointer works? What a...

how pointer works? What are the uses of pointers

Characteristics of object-oriented programming, Characteristics of object-o...

Characteristics of object-oriented programming: • Emphasis is on data rather than procedure. • Programs are divided into what are known as objects. •

Unix, 1. Write a shell script to locate executable files. This script takes...

1. Write a shell script to locate executable files. This script takes a list of file names from the command line and determines which would be executed had these names been given a

To print total no.of ordinary files, Normal 0 false false f...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Java packages, Expertsmind brings you unique solution in java assignments ...

Expertsmind brings you unique solution in java assignments Packages A Java packages is a process for planning Java sessions into namespaces just like the segments of Modu

Fortran function for find and print out all prime number, Write a Fortran L...

Write a Fortran LOGICAL FUNCTION, called "is_prime", which determines if a given integer value is a prime number or not (A prime number is a natural number which has only two disti

Write Your Message!

Name

Email id

Message

Verfication Code

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd