SQL SERVER AND VBA ACCESS FUNCTION - Rehire
This project was successfully completed by diegogarcia0531 for $30 USD / hour in a day.Get free quotes for a project like this
Project Budget$30 USD / hour
Completed In1 day
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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online