Reference Verification

In Progress

Three fields in the database, Candidate Table, need to have their field names changed, and then the resulting errors from the stored procedures, need to be updated to use the New field names, so we don't get errors again. StartDate = Lic_Rev_Date AgentRegisteredBy = Lic_Rev_By DuesPaid = Lic_Status And, I need some update queries run: Lic_Rev_Date - update to null, all records except those containing 1/27/2012, and set default for new records to null Lic_Rev_By - update to null, all records except those containing Diana, Jennifer, or Myra, and set default for new records to null Lic_Status - update to unverified, all records except those containing Expired, Valid, or Not on File, and set default for new records to unverified This is enough for now, but there is more. The errors that are created when the field names change, I will upload screen shots of in a moment, so you will know which pages are affected.

Skills: .NET, ASP, MySQL, PHP, Software Architecture, Software Testing, SQL, Web Hosting, Website Management, Website Testing

See more: jennifer diana, reference , JENNIFER, diana, names change, upload screen, table table valid, startdate, database verification

Project ID: #2711522

Awarded to:

coltech1979

See private message.

$30.6 USD in 2 days
(28 Reviews)
4.8

3 freelancers are bidding on average $26 for this job

JohannesD

See private message.

$30.6 USD in 2 days
(16 Reviews)
3.6
greenglass

See private message.

$17 USD in 2 days
(7 Reviews)
1.4