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).
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
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, there. I've much interested in your project and I've read and understood all of your requirements. I've experienced in Database Administration and Database Programming. I hope to work with you. Thanks.
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.
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
How are you? Dear Sir! As a new freelancer,I am an expert on your proposed skills and have been in this program for over 8 years. I am database expert to handle mysql please contact me. Best regards!!
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 .