MySQL Query Help

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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).

Administración de bases de datos Programación de bases de datos MySQL SQL

Nº del proyecto: #18145142

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 en 1 día
(5 comentarios)
3.0

12 freelancers están ofertando un promedio de $27 por este trabajo

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 Más

$50 USD en 3 días
(25 comentarios)
6.0
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 Más

$20 USD en 0 días
(7 comentarios)
3.5
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 en 1 día
(4 comentarios)
2.5
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 en 2 días
(1 comentario)
0.9
venkatabaskar2

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

$30 USD en 1 día
(0 comentarios)
0.0
mageshr24

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

$20 USD en 1 día
(0 comentarios)
0.0
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 en 2 días
(0 comentarios)
0.0
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 Más

$25 USD en 1 día
(0 comentarios)
0.0