Fill in a Spreadsheet with Data

Ukończone Opublikowano 6 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

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.

Wprowadzanie danych Excel Microsoft SQL Serwer

Numer ID Projektu: #14078143

O projekcie

23 ofert Zdalny projekt Aktywny 6 lat temu

Przyznany użytkownikowi:

lightcresent

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

$55 USD w 1 dzień
(9 ocen)
5.6

23 freelancerów złożyło ofertę za $106 w tym projekcie

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 Więcej

$180 USD w ciągu 2 dni
(152 Oceny)
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. Więcej

$99 USD w ciągu 3 dni
(88 Oceny)
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 Więcej

$30 USD w ciągu 3 dni
(14 Oceny)
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 Więcej

$122 USD w ciągu 1 dnia
(2 Oceny)
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 Więcej

$155 USD w ciągu 3 dni
(14 Oceny)
3.7
istiyaqueahmed

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

$60 USD w ciągu 2 dni
(31 Oceny)
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 w ciągu 3 dni
(7 Oceny)
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 Więcej

$180 USD w ciągu 5 dni
(1 Ocena)
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 Więcej

$55 USD w ciągu 3 dni
(9 Oceny)
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 Więcej

$30 USD w ciągu 1 dnia
(7 Oceny)
1.7
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 Więcej

$40 USD w ciągu 3 dni
(1 Ocena)
1.4
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 Więcej

$55 USD w ciągu 2 dni
(2 Oceny)
1.5
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 Więcej

$30 USD w ciągu 1 dnia
(1 Ocena)
1.1
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 Więcej

$155 USD w ciągu 3 dni
(0 Oceny)
0.0
BETHIBD

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

$40 USD w ciągu 2 dni
(0 Oceny)
0.0
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 Więcej

$155 USD w ciągu 3 dni
(0 Oceny)
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 w ciągu 3 dni
(0 Oceny)
0.0
codetod

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. Więcej

$50 USD w ciągu 2 dni
(0 Oceny)
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 w ciągu 3 dni
(0 Oceny)
0.0