You have chosen to sponsor your bid up to a maximum amount of .
Hello, I love your work and I need a similar code in SQL SERVER 2010 and MS Access.nnPlease 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 equip_no.nnPlease I need this in SQL server Procedure and Access VBA. Similar to the last project you did for me.nNOTE: 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 quickly.nnPlease deliver in 2-3 hoursnn