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
$15 USD v 1 dni
5,0 (5 recenze)
3,0
3,0
12 freelanceři nabízejí v průměru $27 USD za tuto práci
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 together with other specified business intelligence searches and lookup functions.
I am smart enough to take your business requirements and create database queries to reflect the intent of your requirements.
I guarantee writing efficient complex database queries as well as responsive application codes to improve software performance capabilities.
SIMILAR PROJECTS COMPLETED:
• https://www.freelancer.com/projects/sql-database-programming/sql-server-query/?w=f
• https://www.freelancer.com/projects/website-design/database-design-link-site/
• https://www.freelancer.com/jobs/project-15444898/
• https://www.freelancer.com/projects/mysql/review-database-model-for-survey/
• https://www.freelancer.com/projects/sql/human-resources-database-creation/
EDUCATION
• BSc Computer Sciences, University of Hertfordshire, UK 2014
• Microsoft Certified Business Intelligence Developer 2009.
• Microsoft Certified SQL Server Administrator 2008.
• compTIA A+ Certified 2008.
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 experience in Store procedures, Triggers, Views and Custom Functions
we can discuss more details in chat
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
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 .
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 doing DB design.
Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired.
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL)
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS