Write some Software

SQL SERVER 2010 Function to Sort and copy bottom Row and paste it to the top row In the table with large dataset 1. Sort by TRUSTID, [DATE] 2. Loop through the STATUS column, Whenever the code sees Origin, the code should copy the next bottom row from column E to I and paste it to the adjacent column on the right 3. Subtract column E from Column J (J-E) and write the answer in the Diff column O Write it to a table called Time_Analysis_tbl I will be running millions of records and the code should be properly index and quick. I also want a replica code in VBA Access so that I can run it within access and SQL SEVER environment