In Progress


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.

Skills: Microsoft Access, SQL

See more: access 2010 vba sort table sql, run access function sql, access vba sql server, Vba sql, access sql function, access sql server vba, sort function c, microsoft access job, job ms access, c sort function, sql server job, sql microsoft access, ms access sql, microsoft vba, microsoft access sql, in vba, ms access job, ms access 2010, sql microsoft, ms access vba, ms access 2013, MICROSOFT SQL SERVER, microsoft access vba, C3, B3

About the Employer:
( 35 reviews ) Kent, United Kingdom

Project ID: #4849709

Awarded to:


Hi, I can do the project, just accept my bid I understand your requirements, I will do in 2 hours Regards Diego

$30 USD in 0 days
(22 Reviews)