Completed

SQL SERVER AND VBA ACCESS FUNCTION

This project was successfully completed by diegogarcia0531 for $30 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
1
Project Description

I have a flat table containing millions of records (900 million rows)
Write SQL function and VBA function to do the following:
1. Sort Ascending by Train_ID
2. Sort Ascending by Actual_Datetime
3. In the Geography_Name_From Column, copy the second value B3 to the Geography_Name_To Column C2 and B4 to C3 etc
See example in the sample data attached.
When I run the function in SQL Server 2010, it should do the above steps. The function will be run against millions of records hence it should also do the indexing.
I also need the same function in VBA – MS Access
I need this job to be done within 1 – 3 hours.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online