In Progress

Fill in a Spreadsheet with Data

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.

Skills: Data Entry, Excel, Microsoft SQL Server

See more: collection of data and fill in spreadsheet, https www freelancer com projects data entry fill spreadsheet with data 10799431, https://wwwfreelancercom/projects/data-entry/fill-spreadsheet-data-entry/, data-entry/fill-spreadsheet-with-data-entry, fill data spreadsheet, macro cut data spreadsheet copy different spreadsheet, vba macro cut data spreadsheet spreadsheet, excel macro script insert data spreadsheet, contact data spreadsheet, collecting price data spreadsheet, macro data spreadsheet, payroll data spreadsheet, link web data spreadsheet, 2008 extract data spreadsheet, putting tech support data spreadsheet

About the Employer:
( 14 reviews ) Tegucigalpa, Honduras

Project ID: #14078143

Awarded to:

lightcresent

Will write the query right away, will need sql access to test it.............................. Thanks....................

$55 USD in 1 day
(9 Reviews)
5.6

23 freelancers are bidding on average $106 for this job

schoudhary1553

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

$180 USD in 2 days
(152 Reviews)
6.6
sonarkaushik

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

$99 USD in 3 days
(88 Reviews)
6.1
AliSafder

Quick job, let me do it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access,Microsoft Excel (VBA and Charts) and MySQL, Power BI, Charts Pro More

$30 USD in 3 days
(14 Reviews)
4.3
Splaszczyk

- 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

$122 USD in 1 day
(2 Reviews)
4.1
upendra169

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

$155 USD in 3 days
(14 Reviews)
3.7
istiyaqueahmed

Let I handle this project! ---------------------------------------------------------- Send me details please about the work and let’s start right now.

$60 USD in 2 days
(31 Reviews)
3.9
natalka503

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

$100 USD in 3 days
(7 Reviews)
3.1
viju3iyer

Hi Sir.. A good data operator and web researcher, with good knowledge of Internet, MS Office and Adobe (Acrobat, Photoshop and Illustrator) is on your way.. I can give you the best within the turnaround time.. Please h More

$180 USD in 5 days
(1 Review)
2.7
AnumZia

I am truly passionate about Data entry, Email collecting, Web research, Excel, Copy Typing, Copy writing especially copy typing and post ads and Admin support tasks. I am extremely hard-working and dependable. In addit More

$55 USD in 3 days
(9 Reviews)
2.5
heemel25

MD. SHERAZUL ISLAM Hellow, Dear Honorable Project Manager, I am Md. Sherazul Islam. I have been working as a Data Entry professional as well as SMM provider. But, now I am working as a Team membaer. They are More

$30 USD in 1 day
(7 Reviews)
1.7
mianimranamjad

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

$55 USD in 2 days
(2 Reviews)
1.5
SmartestLancer

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

$40 USD in 3 days
(1 Review)
1.4
sodiqa32

We offer best service in business and engineering as a result of our diverse qualification and professionalism. We are reliable, innovative, creative, swift, dependable, effective, and efficient. Three kind of peopl More

$30 USD in 1 day
(1 Review)
1.1
reverential

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

$155 USD in 3 days
(0 Reviews)
0.0
kncgam

I have been working with SQL Server since 2000 and can quickly and efficiently resolve your query error & design issue.

$155 USD in 3 days
(0 Reviews)
0.0
$222 USD in 3 days
(0 Reviews)
0.0
clibuniversity

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

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
sdepuy

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

$155 USD in 3 days
(0 Reviews)
0.0