Fill in a Spreadsheet with Data

Terminé Publié le il y a 6 ans Paiement à la livraison
Terminé Paiement à la livraison

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.

Saisie de Données Excel Serveur SQL Microsoft

Nº du projet : #14078143

À propos du projet

23 propositions Projet à distance Actif il y a 6 ans

Décerné à:

lightcresent

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(9 Commentaires)
5.6

23 freelances font une offre moyenne de 106 $ pour ce travail

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 Plus

$180 USD en 2 jours
(152 Commentaires)
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. Plus

$99 USD en 3 jours
(88 Commentaires)
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 Plus

$30 USD en 3 jours
(14 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
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 Plus

$155 USD en 3 jours
(14 Commentaires)
3.7
istiyaqueahmed

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

$60 USD en 2 jours
(31 Commentaires)
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 en 3 jours
(7 Commentaires)
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 Plus

$180 USD en 5 jours
(1 Évaluation)
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 Plus

$55 USD en 3 jours
(9 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
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 Plus

$40 USD en 3 jours
(1 Évaluation)
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 Plus

$55 USD en 2 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

$155 USD en 3 jours
(0 Commentaires)
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 en 2 jours
(0 Commentaires)
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 Plus

$155 USD en 3 jours
(0 Commentaires)
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 en 3 jours
(0 Commentaires)
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. Plus

$50 USD en 2 jours
(0 Commentaires)
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 en 3 jours
(0 Commentaires)
0.0