MySQL Query Help

เสร็จสมบูรณ์ โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

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

การบริหารฐานข้อมูล การเขียนโปรแกรมฐานข้อมูล MySQL SQL

หมายเลขโปรเจค: #18145142

เกี่ยวกับโปรเจกต์

12 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

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 ใน 1 วัน
(5 รีวิว)
3.0

freelancer 12 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $27

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 เพิ่มเติม

$50 USD ใน 3 วัน
(25 รีวิว)
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 เพิ่มเติม

$20 USD ใน 0 วัน
(7 รีวิว)
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 ใน 1 วัน
(4 รีวิว)
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 ใน 2 วัน
(1 รีวิว)
0.9
venkatabaskar2

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

$30 USD ใน 1 วัน
(0 รีวิว)
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 ใน 1 วัน
(0 รีวิว)
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 ใน 2 วัน
(0 รีวิว)
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 เพิ่มเติม

$25 USD ใน 1 วัน
(0 รีวิว)
0.0