In Progress


Hello, I love your work and I need a similar code in SQL SERVER 2010 and MS [url removed, login to view] see requirements below and attached sample file. Thanksn1. Sort by Equip_no Ascendingn2. Sort by Date_Time Ascendingn3. Sort by Rec_ID Ascendingn4. In Direction_01 Column, copy the D4 to Direction_02 Column E3, n5. D5 to E4, D6 to E5 etc.n6. If the value of Direction_01 Column = Direction_02 Column, write 0 to In the Movement Column and If the value of Direction_01 Column is not equal Direction_02 Column, write 1 to In the Movement ColumnnFor example if D3 (OPEN) = E3 (OPEN) THEN Movement column = 0nFor example if D4 (OPEN) = E4 (CLOSED) THEN Movement column = 1nOnly DO the above function for same Equip_no (column A) 000003015289 will stop at row 139 and row E140 will be null and movement value will be 0nThe next Equip_no 000003017779 will start the process again. See row 141. The value of row E141 must not copy to D140 because the equip_no is different. The processes start again on different [url removed, login to view] I need this in SQL server Procedure and Access VBA. Similar to the last project you did for [url removed, login to view]: I will be running the stored procedure on 400 Million records and it needs to be very quick and indexed. It may run quicker if the code divide the data to each month and then run. You know better but I want it to run very [url removed, login to view] deliver in 2-3 hoursnn

Skills: Microsoft Access, SQL

See more: sort function c, c sort function, ms access sql, me vba, ms access 2010, rehire, project on vba, ms access vba, in process access, ACCESS VBA, vba open access, access vba open, function stored procedure, sql stored function, sql different, run access function sql, vba function, vba example code work, stored procedure function, access vba sql server, Vba sql, attached vba, access sql function, project vba access, access vba 2010

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

Project ID: #4864644

Awarded to:


Hired by the Employer

$30 USD / hour
(23 Reviews)