MySQL Query Help

Imekamilika Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua

$10-30 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

I have a session ID compiled from the following:

Part 1: Julian date (example: 1-365)

Part 2: 4 digit year (example: 2018)

Part 3: Meridian (example: AM or PM)

Part 4 and 5: Other ID values not related to date

Full example: 3162018-AM-1-28

I have a view that aggregates several values from several tables and is built to show data for the current date only. One of the select values is this session_id mentioned above.

In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data, I get repeating records. Instead, there should be a single record for each person defined with a schedule record for the given day.

-- If Part 1 and Part 2 of the session_id is <> to the current Julian date + 4 digit year, it should return as NULL.

-- If Part 1 and Part 2 of the session_id = to the current Julian date + 4 digit year, it should return the full session_id from trip_history table.

I am attaching the the source tables ([login to view URL]) and the view definition ([login to view URL]) for import and examination.

Keep in mind that the view data is date/time sensitive. There are CASE statements in the view SQL that will only allow you to see records from trip_history that were created on the current date in the AM or PM (dependent on the system time).

Usimamizi wa Uhifadhi Data Kuprogramu Database MySQL SQL

Kitambulisho cha Mradi: #18145142

Kuhusu mradi

12 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya CFinger
CFinger

Hello, I have over 7 years of experience in dealing with MySQL and other programming languages. I do need to clarify a few things so please send me a message so we can talk more. Thanks! Caleb

$15 USD kwa siku 1
(Maoni 5)
3.0

12 wafanyakazi huru wanazabuni wastani wa $27 kwa kazi hii

Picha ya Profaili ya fanninson45
fanninson45

INTRODUCTION I can see you are interested in building complex MySQL Query. I have also studied your case studies you wrote in the project description. I can create your SQL procedures, rank, percentile aggregates t Zaidi

$50 USD kwa siku 3
(Maoni 25)
6.0
Picha ya Profaili ya abubakar4248
abubakar4248

Hey i am professionally software engineer having +3 year experience in this field i read the descriptions and understand i have lot of expertise in Database development using MS Sql Server, MySql etc having experie Zaidi

$20 USD kwa siku 0
(Maoni 7)
3.5
Picha ya Profaili ya dalsaniyasonu123
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$30 USD kwa siku 1
(Maoni 4)
2.5
Picha ya Profaili ya dannyyamith
dannyyamith

I'm really good at Mysql, I have 10 years of experience in mysql, java, android and other skills, I think I'm the person you need for your project, look at my portfolio

$25 USD kwa siku 2
(Maoni 1)
0.9
Picha ya Profaili ya venkatabaskar2
venkatabaskar2

I am having 5 years of experience as a SQL developer.

$30 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya mageshr24
mageshr24

I'm full stack developer, I have worked lots of calculation related app and web application like pos,Billing systems.

$20 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya bapun1297
bapun1297

Hi, I have a lot of experience in this field. Now i am currently working in TATA Consultancy Services (TCS) . Give me a chance I think i can Easily do it. Thank you .

$25 USD kwa siku 2
(Maoni 0)
0.0
Picha ya Profaili ya sunilmudunuri
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Zaidi

$25 USD kwa siku 1
(Maoni 0)
0.0
Tuma Mradi Kama huu