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

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 that

Java networking, Expertsmind brings you unique solution in java assignment...

Expertsmind brings you unique solution in java assignments Networking The term system selection represents composing applications that do across several gadgets (computers

Java, how to save bulk entries at a time using collections?

how to save bulk entries at a time using collections?

Pascal program, Pascal program: Exactly what you need to do to generat...

Pascal program: Exactly what you need to do to generate your empirical data is specific to your individual assignment. However, some rules apply to all of you: 1. The gener

Create procedures for accessing the root, (a) Create procedures for access...

(a) Create procedures for accessing the root, left subtree and right subtree, and also mutators for changing the root, left subtree and right subtree of an avl argument. (b) Wr

Shell script to count characters, Normal 0 false false fals...

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

Shell script to display words of a file in ascending order, Normal 0 ...

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

Create xpath expressions and xslt templates, Consider the following schema ...

Consider the following schema (DTD) and sample instance document: name ID #REQUIRED spouse IDREF #IMPLIED job CDATA #IMPLIED > ]>

Calculate the total price to purchase all the components req, Calculate the...

Calculate the total price to purchase all the components required to build a state-of-the-art gaming computer from components available on the internet. Before attempting this exer

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

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