Fill in a Spreadsheet with Data
$30-250 USD
Paid on delivery
I need to write a query or sub query in SQL that will allow me to retrieve the last time that an application was processed. For example a student submits an application that is uniquely identified by a number (ex. application #32765) as 7:00 AM it goes through several steps during the review process (ex 7:05 AM received 8:00 sent for review 9:00 AM Verification of Documentation 10:05 Sent to admission board etc). I need to select just the last time the application was processed along with the processing time, processing status and ID of the application as well as the name of the applicant.
I have attached the name of the tables and the query I have been using and the result of the query when I execute it. Application number is in column DSOLIC, name of applicant is in column DNALN1, status of application is in column DADSCH1 and time of status of application is in column DAHORH.
Project ID: #14078143
About the project
Awarded to:
Will write the query right away, will need sql access to test it.............................. Thanks....................
23 freelancers are bidding on average $106 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More
- Estimation time for delivering solution 1 DAY ( surely by the end of weekend ). - I speak and write English well, so there should be no problem with communication - I'm senior SQL server DBA and MCSA certified so More
Hi, I am a Experienced Data Entry Operator and I have very good knowledge of MS Office Suite (Word, Excel & PowerPoint), I am expert in Internet Research, my typing speed is 70WPM and I am in this field for last 10 ye More
Let I handle this project! ---------------------------------------------------------- Send me details please about the work and let’s start right now.
Hello, I am experienced in that kind of projects and I would like to help you. Please contact me via chat to speak about details. Greetings, Natalie
Hello sir Thankful for the job post. I am a career oriented freelancer of multiple skills. I have just reviewed your attached file. Concentration is the key that is crucial in your project. I have a great command ove More
Hello I’m very interested in your job post involving these skills. I have good experience in Data Entry, Excel and SQL . My typing speed is more than 50 words per minute. I believe my skills would be ideal for your pr More
Degrees in Law, English Lang and Lit. & Comp Sc. I am Versatile: I have degrees in Law, English Language and Literature and Computer Science Lawyer, solicitor, legal drafting, conveyancing, legal writing and researc More
Hello there, I read your project details and able to work with your project , you can hire me to get a Quality Service. I have a teem. Thanks. Bethi
Hello Sir We are providing services over REST web services based apps + E-commerce apps like Magento, Woocommerce based + Social Networking apps, Geo-Locations based apps, Classifieds apps, + Social Media APIs - FA More
I am a systems engineer, with experience in database administration. I am from Panama, so my Spanish is Native and I lived for a while in Lake Charles, Louisiana so I'm fluent in English
I have been working with SQL Server since 2000 and can quickly and efficiently resolve your query error & design issue.