Write a simple SQL Script

$30-250 AUD

Selesai

Dibuat

lebih dari 6 tahun yang lalu

$30-250 AUD

Dibayar ketika dikirim

I require some SQL scripts to be written for some data contained in a spreadsheet. The data contains the plate number, entry time (Lane 2) and the Exit time (Lane 1) for vehicles. I need the following; - Duration of stay during a day (Only duration over singe day, no overlap to next day) No duration given if an exit is not detected - Number of repeat visits by same plate in a day, in a week, in a month. We will use this script in our SQL database to create the required data.

SQL

ID Proyek: 15333889

Tentang proyek

17 proposal

Proyek remot

Aktif 7 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@urmate

Dear Sir/Madam I've excellent database design, SQL programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Database project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif >>>>>>>>>>>>>> Solution within 24 hours

$100 AUD dalam 1 hari

4,9

(34 ulasan)

5,2

17 freelancer menawar dengan rata-rata $130 AUD untuk pekerjaan ini

@asadrana91

I have years of experience in this, i can get you most optimised query. Lets discuss?

$220 AUD dalam 3 hari

4,9

(31 ulasan)

5,8

@SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience with SQL related projects and tasks. I can do this in a full day. Also, I am a near-native English speaker. Relevant Skills and Experience SQL: Advanced English: Near-native Proposed Milestones $120 AUD - Job done.

$120 AUD dalam 1 hari

4,8

(10 ulasan)

4,5

@jyotichauhan0312

I am working in same industry from past 10 years and have good exposure in sql query, SP, Function and trigger etc. Relevant Skills and Experience I have good knowledge of SQL server, Mysql and Oracle etc. Please let me know which database you are using. I can definitely do it. I have 10 years + experience in the same filed. Proposed Milestones $155 AUD - payment after delivery

$111 AUD dalam 3 hari

5,0

(2 ulasan)

3,2

@nidhi1509

I have 5 years of experience working on Database including SQL, MySql, Oracle database etc. I am sure on completing the project successfully.

$90 AUD dalam 1 hari

5,0

(1 ulasan)

1,2

@rolandlawrence

I will complete on time Relevant Skills and Experience c/c++/sql db Proposed Milestones $45 AUD - I will complete on time

$45 AUD dalam 3 hari

3,8

(1 ulasan)

1,1

@shamuztab

Hi, I am software engineering graduate with good command over sql. you can rely on me for the job you are offering. Relevant Skills and Experience I have done multiple projects with implementation of sql and this requires a simple sql operations that will create the results you are required. Proposed Milestones $100 AUD - initial implementation

$100 AUD dalam 3 hari

5,0

(1 ulasan)

0,6

@chali5

Hello Sir! i have read your description, i will write a script which will give you the duration of stay vehicle of one day. If you want quality, efficient and bug free work than contact me. Thanks. Relevant Skills and Experience MySQL(2 Years) Proposed Milestones $155 AUD - SQL Script Task

$155 AUD dalam 3 hari

0,0

(0 ulasan)

0,0

@marlongielow14

Agora mesmo Stay tuned, I'm still working on this proposal.

$172 AUD dalam 10 hari

0,0

(0 ulasan)

0,0

@rztechnologies1

we are team of experts let's discuss .

$35 AUD dalam 1 hari

0,0

(0 ulasan)

0,0

@BizVenture

Hello there. I'm much familiar with SQL script and can finish your project successfully as your requirements. Just drop me a line for furthermore discuss in detail. Regards. Relevant Skills and Experience SQL Proposed Milestones $155 AUD - default

$155 AUD dalam 3 hari

0,0

(0 ulasan)

0,0

@Darwin21015

Hello, c I hope you are well, I seem asado what you ask this I can build it in a stored procedure in the database so that it returns the data that you are needing Habilidades y experiencia relevante My main skills in customer care or systems systems, desktop application development, good execution of sql language, plus basic knowledge in java, python, visual fox Htos propuestos $155 AUD - Query

$155 AUD dalam 1 hari

0,0

(0 ulasan)

1,1

@chandruxp

A proposal has not yet been provided

$55 AUD dalam 15 hari

0,0

(0 ulasan)

0,0

@ericwalter

- Discover which flavor of SQL this needs to be written in (i.e. T-SQL?) - Review data for any integrity issues - Write query for duration of stay report - Write Number of repeat visits Relevant Skills and Experience 12 years of SQL experience 2 years of report writing experience Proposed Milestones $200 AUD - Duration of stay report $77 AUD - Number of repeat visits report Plate 009TIG for 2017-08-04 has 3 entrances and 1 exit for the day, how would you like that handled?

$277 AUD dalam 3 hari